If have written your CRL stored procedure by using Visual
studio 2010 then you know how to debug your CLR stored procedure. That is
simple write click the test script and from menu click debug. And if you convert your project to Visual Studio 2012 then
you may wonder how to debug the CLR Stored Procedure. In VS2012 you cannot debug
test script like VS2010. InVS2012 first you have to open the test script. It
will open like this.
Now you can debug your SP by pressing Execute with debugger.
Before that make sure you have connected to your database
where CLR is running. That can be done by opening SQL Server Object Explorer
from view menu.
Note:
Data base has to be local otherwise you have to enable
remote debugging.
And make sure that your database server is CLR enabled. That
can be checked by using following code.
EXEC sp_configure 'clr enabled' ,1 RECONFIGURE
