On a Visual Studio 2010 database project I created the following table:
CREATE TABLE [dbo].[Resources] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Content] VARBINARY (MAX) FILESTREAM NULL,
[Description] NVARCHAR (800) NULL,
[Key] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
[Locked] BIT NOT NULL,
[Name] NVARCHAR (100) NOT NULL
I keep having the error:
SQL04141: A table with FILESTREAM column(s) must have a non-NULL unique ROWGUID column.
But I do have such a column: Key
What am I doing wrong?
View Complete Post