Questions tagged [sqlclr]
The sqlclr tag has no usage guidance.
9
questions
2
votes
0answers
46 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 ...
26
votes
4answers
233k 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
453 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
477 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 ...
21
votes
3answers
39k 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 ...
4
votes
1answer
2k 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
1answer
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.
...
4
votes
1answer
163 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
762 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 ...