Questions tagged [sqlclr]
9 questions
25
votes
4 answers
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 message "CLR Types for Sql Server 2012" were…
Ted
- 353
- 1
- 3
- 8
24
votes
3 answers
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 function), SQL Server will not honor the updated dll…
Ian Boyd
- 5,131
- 14
- 57
- 79
4
votes
1 answer
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 control system, so he suspects that some code may…
Ed Leighton-Dick
- 1,094
- 1
- 7
- 12
4
votes
1 answer
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 development machine but I am still wondering,
Are there…
dance2die
- 1,961
- 7
- 31
- 40
2
votes
0 answers
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 CLR integration feature of SQL
Server when…
Alex KeySmith
- 701
- 2
- 10
- 19
2
votes
1 answer
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 employee from his desktop folder, and did not get…
Roger Guess
- 263
- 1
- 4
- 11
2
votes
1 answer
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.
exec sp_configure 'clr enabled',…
dnolan
- 121
- 4
1
vote
2 answers
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
Common Language Runtime (CLR) v2.0.50727 not…
ecathell
- 113
- 2
0
votes
1 answer
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 ASSEMBLY for assembly 'myassembly' failed because…
Julius A
- 215
- 3
- 12