What are steps to load a .NET code in SQL SERVER 2005?

Following are the steps to load a managed code in SQL SERVER 2005:-
=> Write the managed code and compile it to a DLL / Assembly.
=> After the DLL is compiled using the "CREATE ASSEMBLY" command you can load the assembly in to SQL SERVER. Below is the create command which is loading "mycode.dll" in to SQL SERVER using the "CREATE ASSEMBLY" command.
CREATE ASSEMBLY mycode FROM ' c: /mycode. dll '

0 comments:

Post a Comment

Blogger news