In order to debug CSAnalytics_SQL directly in Server Management Studio it is necessary to:
- “Allow SQL/CLR Debugging” in the Server browser
- Make sure the .PDB files are registered in the server
- Open Visual Studio as an Administrator
- Attach to process (sqlserv.exe). NOTE: There are 2. One for the express edition, the other one for the developers’ edition. To figure out which one is which, you can use the task manager, and look at the PID in the services tab.
Useful links:
