Debugging Stored Procedure

Hi Folks,

I'm using SQL Server 2005 Express and I need to debug my stored prodedure. I've been reading online that it can be done in the Express edition but no one explains how to do it. There's plenty of instructions online on how to debug stored procedure in the other versions of SQL Server 2005. Do any of you know how to do it?

Thanks in advance

As in SQL Server 2000 , we can not debugg the SP from SQL ENV in SQL 2005. u have to debugg from Visual studio Env.

Check this

http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005

Madhu