SQL Server 2008 T-SQL Debugger

The Transact-SQL debugger in SQL Server Management Studio enables you to find errors in Transact-SQL scripts, stored procedures, triggers, and functions by observing their run-time behavior. You can start the debugger when you are using the Database Engine Query Editor window.

By using the Transact-SQL debugger, you can do the following:

• Step through the Transact-SQL statements in the editor line by line, or set breakpoints to stop at specific lines.
• Step into or over Transact-SQL stored procedures, functions, or triggers that are run by the code in the editor window.
• Watch the values that are assigned to variables, and observe system objects such as the call stack and threads.

Category:

Science & Technology

Tags:

• SQL
• 2008
• T-SQL
• Debugger
• Magenic

[ValeriaPayano]

Good evening, if you please help me install the SQLServer2008 and when I debug the query is there going round and round and noo done anything like your help to install what is wrong.

We thank

Atte,

Doris



[DJSAustin]

I would really like to know: is it possible to step through my C# ASP.NET code and then seemlessly step into the SQL 2008 debugger. THAT is what I really want to do. I don't want to have to debug stored procedures all by themselves; I want to debug them IN CONTEXT of my running code. Thank you for what you're doing!

[PrimephotoStudio]

Thank you for the info.

[guilhermeGeekk]

@MrSate11ite Dude, you need to install SQL Server 2008 ;)

[mrichman]

Good tutorial, but you need to speak with more authority.

[rsmandudeguy]

You really need to speak up. Your voice is sooo monotone. Good info though.

[F22L3]

Thanks for your work, that help me.

[WatchOut4Keith]

thanks for the video it helped me get started. the resolution works better on full screen and if you set to 480p on the video bar of the video itself.(next to volume)

[rayc9999]

Your video is not clear. Cannot make out any of the text on the screen. Bad resolution.

[MrSate11ite]

i have Microsoft Visual Studio 2008 but i can't see SQL Server 2008 ??????