Debugging Stored Procedure

How to Debug the Stored procedure in SQL 2005.
I thnk its thru VS, pls let me know the details or any references.
Thanks
--
RKNETcheck this link..
http://sqljunkies.com/WebLog/nielsb...ategory/99.aspx