How to debug a storeprocedure in sql server 2000 and 2005?

[irkahc]

I have written one stored procedure(SP). Just I want to check whether it is running correctly or not. How can I debug a SP in sql server 2000/ 2005? is there any diff between sql server 2000 and 2005? pls suggest me. thanks, chakri

[Pete OHanlon]

There are many ways to do this. One way would be to print out values at appropriate points.

the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.

[PrashantJ]

In SQL Server 2000, you can right click the stored procedure and debug but for SS2005 I guess you can debug only thro Visual Studio 2005.