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
VisualStudio2012 Debugging Setting for SQL Server 2012 CLR Project.one
http://www.sqlteam.com/article/writing-clr-stored-procedures-in-charp-returning-data-part-2