>>>>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.
>
>Note, this only works in certain editions of VS. In the edition I have (standard edition, thanks to you ), I don't see an option to debug SP.
>
>And apparently there is no such option in SQL Server itself if I'm not mistaken (I'd love to be).

It may only be in VS Pro editions (I've never used standard).

The VS debugger is the only way I found to do it for SQL2005 - nice marketing ploy for MS eh?

FWIW it works well (actually I haven't had to use the debugger in a while - must be my perfect code .. ahem..).