Sunday, February 19, 2012

Debugging acting weird

Hi!
I have VS2005 RC1 and SQL Server 2005 September CTP installed on the same machine.
I'm writing some pretty simple C# stored procedures and I'd like to be able to debug them with with the VS2005 IDE. However, something's not working.
When I set a breakpoint and I run the code (F5), it turns white with a red border informing me that "the breakpoint will not currently be hit. No symbols have been loaded for this document". Obviously, those breakpoints are not hit and I cannot debug exceptions either.
I made sure the connection the project is linked to has "ApplicationDebugging" and "Allow SQL/CLR Debugging" turned on.
I'm probably missing a very simple step to get this working, but Google didn't help me this time. So that's why I come here begging for your help! Big Smile
Thanks in advance!
Carl

Hi Carl,

Have you executed the following TSQL code to enable SQLCLR on the server?

Create a new Stored Procedure in VS, then add the following:

exec sp_configure 'clr enabled',1
reconfigure

If this doesnt work, could you answer the following questions:

1, Are you the running as the machine admin?
2, Are you able to debug a regular TSQL Stored Procedure?
3, Could you send me the text from the output window.

Thanks

Richard Cook
VS SQL Debugger QA

No comments:

Post a Comment