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)
 execution store procedure

Author  Topic 

swarn
Starting Member

12 Posts

Posted - 2003-01-07 : 09:25:45
Hi Folks

I have a store procedure to convert data and update tables with data in sql server 2000. I would like to watch the response of each line while executing this store procedure.

if this is possible then how can i do this. please help...

swarn

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2003-01-07 : 09:53:13
if you have sql server 2k you can use query analyzer to debug or visual studio.

in QA drill down to stored procedure in object browser then right click on sp and choose debug.



Go to Top of Page
   

- Advertisement -