>>Hi everybody,
>>
>>I've created a simple SP and I'd like to test it step by step. Do you know how can I do this in SQL Server 2005?
>>
>>Thanks a lot in advance.
>>
>>UPDATE. Ok, I'll try to follow this article
>>http://aspnet.4guysfromrolla.com/articles/051607-1.aspx
>
>I have Standard Edition of VS 2008, so I don't see Step into option in the Server Explorer of VS.
>
>Is there an option in the SQL Server itself to debug the procedure somehow?
>
>Thanks again in advance.

Hi, Naomi

You could try the Freeware version of Toad for SQL Server. I, believe it has a very good debugger.

It can be found here:

http://www.toadworld.com/
or
http://www.toadsoft.com/toadsqlserver/toad_sqlserver.htm

Regards,