c# - How to debug a CLR Stored procedure in VS 2013 -

i have tried different ways done nothing works. vs seems ignore breakpoints in .cs files when run test script. have included breakpoint in test script still not debugging.

this guide microsoft https://msdn.microsoft.com/en-us/library/ms165051(v=vs.100).aspx tried, don't have "a set default debug script" option when right click on script file.

you might need also:

1. run visual studio admin
2. open additional ports are, default, blocked windows firewall
3. set project startup project.
4. in visual studio: go "sql server object explorer", right-click on instance deploying in "debug" tab of "project properties", , select "allow sql/clr debugging", , click "yes" button in pop-up dialog.
5. if want breakpoints work, cannot have "optimize code" option checked in "sqlclr build" tab of "project properties". default unchecked "debug" configuration , checked "release" configuration. configuration doesn't matter, long option not checked. if was, need uncheck , re-publish , make sure updates assembly (sometimes might not since there no other changes assembly).
6. in visual studio: open new query "sql server object explorer" , in drop-down attached execute ">" button, select "execute debugger" (which alt + f5). breakpoints aren't trapped first time around, execute debugger again.

there might additional things, pretty sure not need default debug script, though posts do.

please see answer here , links in comments on question:

can't attach sql server debug sqlclr stored procedure