Mensaje
De
11/06/2008 11:09:28
a
11/06/2008 11:06:44
General information
Foro:
Microsoft SQL Server
Category:
Mantenimiento de bases de datos
Título:
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
ID de la conversación:
01323060
ID del mensaje:
01323109
Views:
16
>>>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).
>>
>>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).