Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server >> .NET Framework inside SQL Server

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

[912 byte] By [CarlMercier] at [2008-3-3]
«« Cannot select "Server Database Engine" when installing SQL Server Sep 2005 CTP
»» Formatting a String
# 1
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

RichMSFT at 2007-9-9 > top of Msdn Tech,SQL Server,.NET Framework inside SQL Server...
SQL Server
.NET Framework inside SQL Server

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified