Must .Net dll be on the local sql server? | SQL Server Performance Forums

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 StringConcat
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
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.