Help! I recently had to re-install IIS and the .NET framework, and now I can no longer use Visual Studio to debug my stored procedures. In an attempt to fix this problem, I uninstalled and re-installed IIS, .NET, and Visual Studio 2005, all to no avail. I haven't yet uninstalled/re-installed SQL 2005.
Here's what happens - I connect to SQL 2005 through Server Explorer. I have Application Debugging and SQL/CLR debugging checked. I open a stored procedure and set a breakpoint. I run my project, and, unfortunately, it doesn't stop at the breakpoint. It completely ignores the breakpoint and keeps on doing it's thing. Aaaah!
It's possible that in the process of uninstalling and reinstalling stuff, I may have accidentally changed some accounts or permissions (I may have assigned admin privelages to a few accounts) although I don't know if this is my problem.
I'm hoping that someone out there can help me as I don't want to do a full re-formatting of my machine.