Adding CLR Stored Procedures to a Database
If you’ve already created and compiled a CLR stored procedure, the next step is to install that CLR procedure in the database. The first step in this process is to copy the .NET assembly to a location that SQL Server can access and then load it into SQL Server by creating an assembly. The syntax for the CREATE ASSEMBLY
command is as follows:
AssemblyName
is the name of the assembly, and StringPathToAssemblyDll
is the path to the DLL. The path can be a local path, but often this path is a network share.
The WITH
clause is optional, and it defaults to SAFE
. Marking an assembly with the SAFE
permission ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.