>>>Is there a way to execute a script one line at a time in the SQL Server Management Studio? Like I can in the Foxpro debugger? Can I also see values/results as it is executing?
>>
>>You can highlight the line and try to execute it. I'm not sure there is another way.
>
>You can open a database project (pick your database as the project) in Visual Studio and debug SPs there.

See my reply to you <g>