You are currently offline, waiting for your internet to reconnect

FIX: Error message when you define multiple permissions that use INCLUDE or EXCLUDE treatments in Microsoft Visual Studio Team System 2008 Database Edition GDR: "An object can only have either INCLUDE or EXCLUDE treatment on its columns"

SYMPTOMS
You have a database project in Microsoft Visual Studio Team System 2008 Database Edition GDR. In the Database.sqlpermissions file, you define multiple permissions that use INCLUDE or EXCLUDE treatments on different columns of the same table or view. However, when you build the project, you receive the following error message in the Error List window:
TSD03110: An object can only have either INCLUDE or EXCLUDE treatment on its columns.
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
You experience the problem when you define permissions in the Database.sqlpermissions file that resemble the following:
<PermissionStatement Action="DENY"> <Permission>SELECT</Permission>   <Grantee>User1</Grantee>   <Object Name="Table1" Schema="dbo" Type="OBJECT">   <Columns Treatment="EXCLUDE">   <Column Name="A"/>   <Column Name="B"/>   </Columns>         </Object>  <Grantor>BedrockDBA</Grantor>  </PermissionStatement>  <PermissionStatement Action="DENY">  <Permission>SELECT</Permission>  <Grantee>User1</Grantee>  <Object Name="Table1" Schema="dbo" Type="OBJECT">  <Columns Treatment="EXCLUDE">  <Column Name="C"/>  <Column Name="D"/>  </Columns>  </Object>  </PermissionStatement>
Properties

Article ID: 970580 - Last Review: 07/16/2009 08:05:54 - Revision: 1.0

Microsoft Visual Studio Team System 2008 Database Edition

  • kbexpertiseadvanced kbprb kbsurveynew kbqfe KB970580
Feedback
e="display:none;" onerror="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">