Re: How to debug stored procedure in sql server
From: Vinodk (vinodk_sct_at_NO_SPAM_hotmail.com)
Date: 03/31/04
- Next message: John Gilson: "Re: find a value in database"
- Previous message: SriSamp: "Re: Comments?"
- In reply to: Greg Linwood: "Re: How to debug stored procedure in sql server"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 31 Mar 2004 11:56:45 +0530
Adding to Greg's thread. Investigate if you have SQL Server SP3 /SP3a
installed. Because the debug feature is disabled by default. You need to
explicitly enable the same. Refer to the release notes for the service packs
for further information.
-- HTH, Vinod Kumar MCSE, DBA, MCAD, MCSD http://www.extremeexperts.com Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp "Greg Linwood" <g_linwoodQhotmail.com> wrote in message news:uqI7mFuFEHA.1840@TK2MSFTNGP12.phx.gbl... > (a) Open Query Analyser > (b) Connect to Server > (c) Press F8 for Object Browser > (d) Expand Database > (e) Expand Stored Procedures > (f) Right click on Stored Procedure you want to debug > (g) Select "debug" from menu > > Begin debugging from there.. Use F10, F11 for step into / over etc. > > Regards, > Greg Linwood > SQL Server MVP > > "Iter" <anonymous@discussions.microsoft.com> wrote in message > news:99C0890C-5A1F-464C-94EF-F3B5FC2AA1F0@microsoft.com... > > How to debug complicated stored procedure in sql server query analyzer or > Profiler. I can set break point,stop there, can see the value of variable. > thanks. > > > >
- Next message: John Gilson: "Re: find a value in database"
- Previous message: SriSamp: "Re: Comments?"
- In reply to: Greg Linwood: "Re: How to debug stored procedure in sql server"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
