SQL Server Performance Forum – Threads Archive
Must .Net dll be on the local sql server?
I was not able to create assembly when my .NET project was compiled on the remote machine. For instance this failed: CREATE ASSEMBLY StringConcatAUTHORIZATION [dbo]
FROM ‘\remoteD$CLRMyExample.dll’
WITH PERMISSION_SET = safe; so only when I copied this to the local sql server I was able to create assembly. Is this always the case? However, when I DEPLOYED the project, the assembly automatically appeared on my sql server, and the function was there too. I did not even have to create an assembly. Thanks
Yes the .NET dll must be on the local server in order to read the required values by SQL engine. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
]]>