Questions tagged [sqlclr]
The sqlclr tag has no summary.
9 questions
2 votes
0 answers
76 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 ...
- 721
25 votes
4 answers
250k 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 ...
- 353
1 vote
2 answers
525 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 ...
- 113
2 votes
1 answer
510 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 ...
- 293
24 votes
3 answers
49k 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 ...
- 5,463
4 votes
1 answer
3k 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 ...
- 1,094
2 votes
1 answer
1k 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. ...
- 121
4 votes
1 answer
179 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 ...
- 2,051
0 votes
1 answer
812 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 ...
- 215