Debug SQL Server CLR Stored procedure by using Visual Studio 2012

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.

 Then select your date base from drop down and start debug…

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