Cannot drop duplicate unique constraint on ROWGUID column on FILESTREAM table - by Martin Smith

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 715467 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/25/2011 12:55:37 PM
Access Restriction Public


If a table with FILESTREAM column(s) erroneously gets redundant unique constraints added it is not possible to drop  the duplicate constraint(s) via "DROP CONSTRAINT".

This raises the error "A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column." even though the table would still meet that criteria after the drop.
Sign in to post a comment.
Posted by Alex [MSFT] on 1/20/2012 at 2:13 PM
This has been fixed in SQL 2012.

Posted by Srini [MSFT] on 1/20/2012 at 11:16 AM
Hi Martin,
Thanks for filing this issue about not being able to drop duplicate constraint from FILESTREAM table. This seems like a defect. We will investigate this to see how this can be mitigated in one of our releases after SQL 2012.

SQL Server