FIX: The Database.sqlpermissions file is always built even when the imported permissions are not added to the in-memory model of the database in Microsoft Visual Studio Team System 2008 Database Edition GDR

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

On This Page

SYMPTOMS

When you build a project in Microsoft Visual Studio Team System 2008 Database Edition GDR, the Database.sqlpermissions file is always built even when the imported permissions are not added to the in-memory model of the database. This problem causes performance issues in the database project. For example, after you edit the permissions and then rebuild the project, the response time may be very long.

Note The extent of this performance issue depends on the number of permissions in the Database.sqlpermissions file.

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.

MORE INFORMATION

Steps to Reproduce the Problem

  1. You create a SQL Server database project.
  2. You right-click the project in Solution Explorer and then click the Import Database Objects and Settings item.
  3. In the Import Database Wizard dialog box, you set a connection to import a database.
  4. Under the Import options, you select the Import permissions check box and click to clear the Add imported permissions to the project model check box, and then you click Start.

    Note If you select this check box, the in-memory model of the database will include the permissions that you imported from the source database. If you clear this check box, permissions will be imported but will not be added to the model.
  5. After the import of database schema is complete, you click the Finish button.
  6. You expand the Properties node of the project, and then right-click the Database.sqlpermissions file and select the Properties item.
  7. You find the value of Build Action field is Build. However, the expected result is Not in Build.
For more information about the permission options in the new database project wizard, visit the following Microsoft Web site:
http://msdn.microsoft.com/en-us/library/aa833155.aspx

Properties

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

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