Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 debug SP

Author  Topic 

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2002-04-19 : 01:53:26


do we have debugger in sql 2k to debug store procedure...
the bol talk about the icons but not able to find....
can any one help me out where can i access / find it

thanks

======================================
Ask to your self before u ask someone

VyasKN
SQL Server MVP & SQLTeam MVY

313 Posts

Posted - 2002-04-19 : 04:23:42
Yes, SQL Server 2000 comes wuth an inbuilt T-SQL debugger. First, connect to your SQL Server using Query Analyzer. Press
F8 key to open the 'Object browser' pane on the left hand side (if it is not already open). In the Object browser, drill down the the required stored procedure. Right click on the stored procedure and select 'Debug...' from the popup menu. You can also invoke debugger from Tools -> Object browser -> Debug...

--
HTH,
Vyas
Check out my SQL Server site @
http://vyaskn.tripod.com
Go to Top of Page
   

- Advertisement -