VisualStudio2012 Debugging Setting for SQL Server 2012 CLR Project

카테고리 없음 / 2014. 8. 5. 13:56

debugging 수동으로 하시진 않나요? 자동으로 하는 방법입니다.

visualstudio 많이 변했네요....그런데 2013도 나왔다고 하는군요 흐미~

Hi after a long time searching over internet, Your Question has Given me Answer of Our Question. Please understand following very carefully,

Start Visual Studio 2012 with Elevated permissions of Administrator
Create SQL Server Project
In Project Settings/Debug Pane, Provide Connection String for Database Connection
From View Menu, Open SQL Server Object Explorer, If your connection string provided in Project doesn't create Instance of Server, then Recreate connection here...
Right click on Instance and Select Allow SQL CLR Debugging, it will show some warning accept everything but read warnings carefully.
Save Project and perform Rebuild, and test a Publish of project by Generated Publish Script.
Now Create a non-deployment script in project, put a break point press ALT+F5 to execute script with Debug option, when clr-procedure will occur and try to go inside it, it will ask for process to attach with windows, Please allow to Attach

above step worked for me, and here a screen shot of it; "http://i.stack.imgur.com/GQwlt.png"

For more information you can also contact me on; Vinod W. B. @ vinodwb@live.com