Dropping duplicate|redundant Unique Constraint from FILESTREAM table

Posted by electricsk8 on Server Fault See other posts from Server Fault or by electricsk8
Published on 2011-01-03T20:13:49Z Indexed on 2011/01/03 20:55 UTC
Read the original article Hit count: 224

Filed under:

filestream

I have a table with a FILESTREAM column, and it has two unique constraints specified for the same FILESTREAM column, ie:

ALTER TABLE [dbo].[TableName] ADD CONSTRAINT [UQ_TableName_33C4988760FC61CA] UNIQUE NONCLUSTERED ([GUID_Column]); GO

ALTER TABLE [dbo].[TableName] ADD CONSTRAINT [UQ_TableName_33C49887145C0A3F] UNIQUE NONCLUSTERED ([GUID_Column]); GO

I'd like to drop one of the unique constraints, as they are duplicates. However, when I try and drop one of the two duplicate constraints, I receive the following error.

"A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column."

Anyone know how to remove one of the two constraints?

Related posts about filestream

SQL SERVER – Guest Post – Jacob Sebastian – Filestream – Wait Types – Wait Queues – Day 22 of 28

as seen on SQL Authority - Search for 'SQL Authority'
Jacob Sebastian is a SQL Server MVP, Author, Speaker and Trainer. Jacob is one of the top rated expert community. Jacob wrote the book The Art of XSD – SQL Server XML Schema Collections and wrote the XML Chapter in SQL Server 2008 Bible. See his Blog | Profile. He is currently researching on… >>> More
Silverlight 4.0 FileStream

as seen on Stack Overflow - Search for 'Stack Overflow'
FileStream fileStream = new FileStream(filePath, FileMode.Open, FileAccess.Read); Arguments: << path Debugging resource strings are unavailable. Often the key and arguments provide sufficient information to diagnose the problem. See http://go.microsoft.com/fwlink/?linkid=106663&Version=4… >>> More
SQL Server 2008: FileStream Insertion Failure w/ .NET 3.5SP1

as seen on Stack Overflow - Search for 'Stack Overflow'
I've configured a db w/ a FileStream group and have a table w/ File type on it. When attempting to insert a streamed file and after I create the table row, my query to read the filepath out and the buffer returns a null file path. I can't seem to figure out why though. Here is the table creation script: … >>> More
C# System.IO.Filestream doesn't support Hebrew

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all Am I missing something or does System.IO.Filestream not read unicode txt files containing Hebrew? Thanks Jonathan >>> More
Synchronization requirements for FileStream.(Begin/End)(Read/Write)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is the following pattern of multi-threaded calls acceptable to a .Net FileStream? Several threads calling a method like this: ulong offset = whatever; // different for each thread byte[] buffer = new byte[8192]; object state = someState; // unique for each call, hence also for each thread lock(theFile) { … >>> More

Developer IT