>>>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).
If it's not broken, fix it until it is.
My Blog