viernes, 30 de septiembre de 2005 18:57Hi!
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!
Thanks in advance!
Todas las respuestas
lunes, 03 de octubre de 2005 20:15Hi 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
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.
VS SQL Debugger QA