Sunday, February 19, 2012

Debuggin in 2005

Can you debug on a local install in 2005?

NO, you must use Visual Studio 2005 w/SQL Server 2005 to obtain debugging capabilities for tsql, clr, SSIS, and others.

you should be able to use just the Business Intelligence Development Studio (comes with sql server 2005) to debug locally though w/o the full blown VS 2005 product. Select View/Server Explorer, connect to your local sql server, expand stored procs and select step into etc.

|||i doubt (never tried it) that the new advanced Express edition's BI studio has debugging but you could try it. If your not using Express your "golden" as you have BI studio allready. Regardless, you can navigate to the below link for http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx on the BI Studio and other features per edition of SQL Server 2005.|||did this help?

No comments:

Post a Comment