FIX: The computed column is missing when you redeploy the project to a database in Microsoft Visual Studio Team System 2008 Database Edition GDR

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

SYMPTOMS

Consider the following scenario in Microsoft Visual Studio Team System 2008 Database Edition GDR:
  • You add a table that contains a computed column as the last column to a database project.
  • You deploy the project to a database.
  • You redeploy the project to the database.
In this scenario, when you view the table in the database, the computed column is missing.

CAUSE

This problem occurs because the incremental deployment alters the table and drops the computed column, and then tries to alter the column to add a collation. However, Microsoft SQL server does not store the collation when the table is created for the first time because the collation matches the default collation of the database at that moment. Therefore, the collation is not added and the column is missing.

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: 970588 - Last Review: July 16, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Visual Studio Team System 2008 Database Edition
Keywords: 
kbprb kbexpertiseadvanced kbsurveynew kbqfe KB970588

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