Using CLR Integration in SQL Server 2005.
1. Write a simple “Hello World” program
2. Compile the "Hello World" Stored Procedure
3. Open SQL Server Management Studio and create a new query, connecting to the AdventureWorks sample database, then enable CLR Integration.
Next, let’s create the assembly in SQL Server.
The permissions you can set when are as follows:
To verify the existence of the assembly, query the sys.assemblies table.
Now you can access the HelloWorld method by using the create procedure statement.
Run the procedure like a normal one.
If you would like to remove the procedure and the assembly do the following:
Getting Started with CLR Integration
.Send mail to
questions or comments about this web site.