Visual Studio - Debugging SQL Servers SPs from VS.NET2003

Author

Debugging SQL Servers SPs from VS.NET2003

Chad

2004-12-21, 3:59 pm

I have debugged stored procedures by selecting the Server Explorer,
selecting a SP, an click "Step Into."

However, is it possible to write .NET code (for example VB.NET code that
uses ADO.NET to access the database) that calls a SP using an ADO.NET
Command object and be able to step into a SQL Server Stored procedure, debug
it, and return?

This would be great. For many stored procedures that require many parameters
to be manually entered, this would be a great feature.

I heard that it can be done but I haven't been able to find out how.

Éric Moreau [VB MVP]

2004-12-21, 8:57 pm

Yes it is possible.

-First, it requires VS.Net Enterprise.
-Into the project's properties, you need to check "SQL Server debugging" in
the Debugging tab (under Configuration properties).
-You need to execute this line on your SQL Server (using Query analyzer) :
sp_sdidebug 'legacy_on'

After all this, if you have proper rights, you should be able to step into a
SP.
--

HTH

Éric Moreau
MCSD, Visual Developer - Visual Basic MVP
(http://aspnet2.com/mvp.ashx?EricMoreau)
Conseiller Principal / Senior Consultant
Concept S2i inc.(www.s2i.com)

"Chad" <chad.dokmanovich@unisys.com> wrote in message
news:cq9geg$kj9$1@trsvr.tr.unisys.com...
>I have debugged stored procedures by selecting the Server Explorer,
>selecting a SP, an click "Step Into."
>
> However, is it possible to write .NET code (for example VB.NET code that
> uses ADO.NET to access the database) that calls a SP using an ADO.NET
> Command object and be able to step into a SQL Server Stored procedure,
> debug it, and return?
>
> This would be great. For many stored procedures that require many
> parameters to be manually entered, this would be a great feature.
>
> I heard that it can be done but I haven't been able to find out how.
>

Sponsored Links