SQL Server Performance

Must .Net dll be on the local sql server?

Discussion in 'SQL Server 2005 General Developer Questions' started by sql_machine, Jun 25, 2006.

  1. sql_machine New Member

    I was not able to create assembly when my .NET project was compiled on the remote machine. For instance this failed:

    CREATE ASSEMBLY StringConcat
    AUTHORIZATION [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
  2. satya Moderator

    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.

Share This Page