FIX: The setting in the Sql command variable file is not generated in the deployment script when you use the My isolated development environment option in Microsoft Visual Studio Team System 2008 Database Edition GDR

Article translations Article translations
Article ID: 970560 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You use the My isolated development environment option in Microsoft Visual Studio Team System 2008 Database Edition GDR to generate a deployment script. However, the Sql command variable file is not generated in the deployment script.
For example, you perform the following actions in a Microsoft SQL Server database project in Visual Studio Team System 2008 Database Edition GDR:
  • In the Deploy tab of the project properties, you click the Configure deployment settings for drop-down list and select the My isolated development environment option.
  • You define a variable in the Sql command variables file.
  • You deploy the project to a database.
In this example, you notice that the SETVAR statement for the variable is not included in the generated deployment script as expected.

CAUSE

This problem occurs because there is a bug in the .targets file that breaks the isolated development environment.

RESOLUTION

To resolve this problem, upgrade to Microsoft Visual Studio Team System 2008 Database Edition GDR R2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
970479 List of fixed issues in the Microsoft Visual Studio Team System 2008 Database Edition GDR R2

Note Microsoft Visual Studio Team System 2008 Database Edition GDR R2 replaces Microsoft Visual Studio Team System 2008 Database Edition GDR.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 970560 - Last Review: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbprb kbexpertiseadvanced kbsurveynew kbqfe KB970560

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com