stored porcedure ?

[Vijayitsb]

Hi, How to Debug stored porcedure SQL server 2000 ?

Thank& Regards Vijay s

[John_Adams]

Hi Vijay, If you are looking to debug a stored procedure within SQL Server 2000 then I would like to mention that it consits several steps which is hard to explain here. Thefore, I would suggest you go through the following article which explains debugging process (within SQL Server 2000) step by step. http://www.15seconds.com/issue/050106.htm[^] I hope this helps.

Regards, John Adams ComponentOne LLC

[ashish bhakhar]

if you want to debug the stored procedure, open a stored procedure and right click and select the option 'step into stored procedure', you can debug stored procedure without debugging your application.