debugging in sql server 2005

22 Oct 2007 6:50 PM

Wendy Elizabeth

Can you 'step' through code in sql server 2005 express like you can in visual
studio.net 2005? I want to be able to debug code on my own workstation since
my company does not have a 'test' sql server for me to use.
Does the developer's version of sql server 2005 allow you to step through
the sql?
Would this execute properly on my work station?

22 Oct 2007 9:53 PM

Erland Sommarskog

Wendy Elizabeth (WendyElizab***@discussions.microsoft.com) writes:

> Can you 'step' through code in sql server 2005 express like you can in
> visual studio.net 2005? I want to be able to debug code on my own
> workstation since my company does not have a 'test' sql server for me to
> use.
> Does the developer's version of sql server 2005 allow you to step
> through
> the sql?
> Would this execute properly on my work station?

To debug stored procedures you need Visual Studio. There is no support
for debugging in the SQL tools for SQL 2005.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx