sp_configure 'clr enabled',1 GO RECONFIGURE use AdventureWorks GO create assembly ExampleProcess from 'C:/Users/Roy/Documents/Visual Studio 2008/Projects/ExampleProcess/ExampleProcess/bin/Release/ExampleProcess' create proc spCLRExample ( @outval int = NULL OUTPUT ) AS EXTERNAL NAME ExampleProcess.StoredProcedures.ExampleSP declare @OutVal int exec spCLRExample @OutVal OUTPUT SELECT @OutVal