FIX: The ALTER ANY DATABASE AUDIT and the ALTER ANY SERVICE AUDIT permissions are missing from the schema model list in Microsoft Visual Studio Team System 2008 Database Edition GDR

SYMPTOMS
In Microsoft Visual Studio Team System 2008 Database Edition GDR, the ALTER ANY DATABASE AUDIT and the ALTER ANY SERVER AUDIT permissions are missing from the schema model list. For example, you perform the following actions:
  • You create an SQL script file to add a user and grant the ALTER ANY DATABASE AUDIT permission to the user.
  • You right-click a database project and select Import Script item in the Solution Explorer.
  • In the Import SQL Script File wizard, you select both the Import permissions check box and the Add imported permissions to the project model check box.
  • When the import operation is complete, you click the Finish button.
In this example, you notice that the ALTER ANY DATABASE AUDIT permission is not added in the Database.sqlpermissions file as expected.
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: 970576 - Last Review: 07/16/2009 08:11:48 - Revision: 1.0

Microsoft Visual Studio Team System 2008 Database Edition

  • kbexpertiseadvanced kbprb kbsurveynew kbqfe KB970576
Feedback