Installation Instructions
Download the proper binary from the
latest release of ASSP
Start by opening SQL Server Management Studio (SSMS)
- If you want the Assembly available to all databases, right clicking on the Assemblies node under the Server.
- If you only want the Assembly available to a single database, right click on the Assemblies node under that database.
Then choose the "new Assembly..." option
When the register assembly dialog box comes up, use the browse button to locate the ASSP.DLL file.
The other important choices to make are what name to give to the assembly reference and what security permissions to allocate. Keeping the default name of "ASSP" will mean that all of the example scripts should work without modification. Note that there are some functions that will only work if the assembly is registered with unrestricted permissions.
For ASSP2012, you must unblock the DLLs before registering them because .NET 4.0 added this restriction. If you don't unblock the DLL, then you will get the "Clr Assembly must have main file specified." error. Right click on the file and choose Properties and unblock:
