The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
0answers
20 views

How much memory / processors will cause SQLCLR to fail to load?

I'm considering enabling SQLCLR on our SQL2005 production server, however technet states: Computers configured with large amounts of memory and a large number of processors may fail to load the ...
4
votes
2answers
21k views

Install SQL CLR types & Report Viewer 2012 on Sql 2008 server

I'm in the process of installing a client's ASP.net site on a Windows Server 2003 box running Sql 2008. The site uses Report Viewer 2012, but when I attempted to install it on the server, I got the ...
1
vote
2answers
318 views

dotnet framework 2.0 sp2 breaks CLR integration in SQL server

It appears that CLR integration does not like Dotnet framework 2.0 sp2. I am getting the following error message when trying to run code that depends on the clr. Msg 6510, Level 16, State 11, Line 1 ...
2
votes
1answer
247 views

What does SQL 2005 do with a dll provided when you register an assembly?

We inherited a legacy SQL 2005 database. Two assemblies were setup to be used by triggers in one of the databases (ouch). The folder/files were delted by mistake. They were installed by a previous ...
3
votes
2answers
6k views

How to update a CLR Assembly without dropping assembly from SQL Server

How can i update a CLR function (or procedure) assembly dll without having to drop and re-create the assembly in SQL Server (2008 R2)? As it stands now if i update an assembly (e.g. to add a new ...
3
votes
1answer
1k views

Extracting a SQLCLR assembly

One of our in-house applications has a SQLCLR assembly which is currently experiencing problems. The developer is having problems recreating the issue using the version that is stored in our source ...
2
votes
0answers
523 views

SQL CLR not properly enabling

We have a SQL server running SQL 2005 Workgroup 64 bit (9.0.4273), on Windows 2003 server 64 bit. We have run sp_configure and reconfigured the server which indicates that the clr is now enabled. ...
4
votes
1answer
128 views

List of things to check before turning on SQL Server CLR?

I am trying to deploy a CLR function (which computes a hash of a text or a file, not available from SQL Server) for the first time on a production server. I was able to test the function on a ...
0
votes
1answer
616 views

Creating CLR Assembly in SQLServer 2005

I am getting the following error message when I try install my .NET assembly int SqlServer 2005. My .NET assembly references 'ChilkatDotNet2.dll' assembly. Msg 6544, Level 16, State 1, Line 1 CREATE ...