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" <iw***@theagency.com> wrote in message
news:4b****************************@phx.gbl...

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

[Joe Sullivan]

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

Thanks,
Joe

-----Original Message-----
You DID install debugging support onthe SQL Server, right?
This just works with expanded SQL Servers, which you should not do onproduction servers.

--
Regards

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

"Joe Sullivan" <iw***@theagency.com> wrote in message
news:4b****************************@phx.gbl...

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

.