SSDT: Confusion between UDDT and Table - by Jerome Haltom - work

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 766646 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 10/8/2012 3:33:33 PM
Access Restriction Public


I have a user defined data type named 'Period', and a table, also named 'Period'.

The following statement, inside Period.sql, for the table, in SSDT, causes an error:

GRANT SELECT ON [dbo].[Period] TO [isis_datareader] Error 193
SQL71501: Permission has an unresolved reference to object [dbo].[Period].

However, simply running that statement inside SQL works fine. It knows that I'm referring to the table.

SSDT is confusing the two equally named values, even though SQL is perfectly okay with it.

I have no intentions of renaming this type or table simply to satisfy SSDT. I can grant the appropriate permissions by using sp_exec in a PostDeployment script. It is however ugly.
Sign in to post a comment.
Posted by Microsoft on 10/15/2012 at 12:16 PM
Hey Jerome,

Per our discussion on your forum post here -, we have an existing work item tracking this bug, so I have Resolved this as a duplicate of that issue. Thanks again for submitting this issue and providing rapid feedback.

Adam Mahood
Program Manager