Debugging MS SQL Server procedured within Visual Studios .NET

[Joe Sullivan]

I have noticed that Visual Studios .NET has a debug mode
for SQL statements, but I can't seem to get it to work
with MS SQL Server. I can't seem to pull up my stored
procedures from the Server Explorer to set breakpoints.
Does anyone know if this can be done? I can open my
stored procedures from an MS Access project... it seems
odd to me that I have greater debugging tools in Access
than in VS.

Thanks,
Joe

 

[Thomas Tomicek [MVP]]

You DID install debugging support onthe SQL Server, right?

This just works with expanded SQL Servers, which you should not do on
production servers.

--
Regards

Thomas Tomiczek
THONA Software & Consulting Ltd.
(Microsoft MVP C#/.NET)

 

[Joe Sullivan]

I am not sure. Is there any way I can tell from
Enterprise Manager?

Thanks,
Joe