Debug Stored procedure

All ,

How can i debug the stored procedure , Is there is any way to do the same..

Ashsih

itsAshish,

What version of SQL server are you saking about?

You can use "Query Analyzer" for 2000 and you need VS 2005 for 2005 version.

AMB

|||

I have having sql server 2005 . There is SSIS sql task which execute the stored procedure and i need to bedug that.

|||If you have Visual Studio, you can connect to the server from Server Explorer. Then you can navigate to the stored procedure, right click, and select Step Into Stored Procedure.

See http://support.microsoft.com/default.aspx/kb/316549