In SQL Server 2008 SSMS run T-SQL code in debug mode

SQL server 2008 reintroduced the T-SQL debugging feature in SSMS. Near the execute button a green Debug button is placed. In debug mode we can break the process at any line using breakpoint, watch variables and expressions using Add Watch, monitor Locals, Call stack and threads as in Visual studio.