Showing posts with label functionality. Show all posts
Showing posts with label functionality. Show all posts

Friday, February 17, 2012

Debug SQL in SQL Server 2005

Does anyone know how to debug T-SQL in SQL Server 2005? I could not find the
same functionality as in SQL 2000.
Thanks,
LijunThe T-SQL debugger has been removed in SQL Server 2005. To debug T-SQL you
have to use Visual Studio 2005 or later. See the following articles for more
details:
http://blogs.msdn.com/sqlprogrammability/archive/2006/04/29/586495.aspx
http://msdn2.microsoft.com/en-us/library/s0fk6z6e(VS.80).aspx
SQL Server 2008 will add back the T-SQL debugger.
HTH,
Plamen Ratchev
http://www.SQLStudio.com