By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,524 Members | 1,589 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,524 IT Pros & Developers. It's quick & easy.

Visual Studio 2003 to SQl Server 2000

P: n/a
Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003 ?
Thanks,
Smith
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Tue, 7 Jun 2005 14:13:35 -0700, "Allen Smith"
<AS***********@hotmail.com> wrote:
Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003 ?
Thanks,
Smith


Depends on what you mean by debug. You can trap SQL errors with a
Try/Catch structure and in the Catch you can display the SQL error
with the Exception.Method property.

Nov 21 '05 #2

P: n/a
Yes it's possible. See
http://msdn.microsoft.com/library/de...ldebugging.asp

--
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)

"Allen Smith" <AS***********@hotmail.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003
?
Thanks,
Smith

Nov 21 '05 #3

P: n/a
Yes you can. Search the MSDN help file for 'debug stored procedure' and
you'll find everything you need to know.

Briefly, you right-click on the stored procedure from the server explorer,
and select 'step into stored procedure'. Once you're in, you are prompted
for any input parameters and then can step through the procedure. You have a
locals window, a watch window, and can set break points and so forth.

One thing you'll probably have to do manually is give yourself execute
permissions on the master.sp_sdidebug stored procedure, which you'll find in
the extended stored procedures section in Enterprise Manager.

So far I haven't found any way to leave a breakpoint in the stored procedure
and have it hit from application code. It doesn't look like it's possible.

Tom Dacon
Dacon Software Consulting

"Allen Smith" <AS***********@hotmail.com> wrote in message
news:#D**************@TK2MSFTNGP09.phx.gbl...
Is it possible to debug a stored procedure in SQL Server 2000 from VS 2003 ? Thanks,
Smith

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.