debugging sql server 2005 database

I would like to know how to 'step through' sql in a stored procedure in a sql server 2005 standard edition database. I would be using visual studio.net 2008 professional version to step through the code.

it is available in sql 2008 onwards but not in 2005.
But you can use the print command and variables after every line where you want to see the result for debugging the SP.