Updating rowguidcol error
Use File Stream DBGOCREATE TABLE [File Stream Data Storage]( [ID] [INT] IDENTITY(1,1) NOT NULL, [File Stream Data] VARBINARY(MAX) FILESTREAM NULL, [File Stream Data GUID] UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL UNIQUE DEFAULT NEWSEQUENTIALID(),[Date Time] DATETIME DEFAULT GETDATE())ON [PRIMARY]FILESTREAM_ON File Stream Group GO Inserting FILESTREAM Data to File Stream Data Storage Table Let's add a row to the File Stream Data Storage table by execute the T-SQL below. JPG which is stored in the "C:\Sample Files" folder.
Before you run the below code, make sure you have changed the name of the file (C:\Sample Files\Image1.
Error: 5540, Severity: 16, The FILESTREAM column cannot be used with method %ls because the associated ROWGUIDCOL of the base table is nullable or does not have a unique constraint.
Error: 5539, Severity: 16, The ROWGUIDCOL column associated with the FILESTREAM being used is not visible where method %ls is called.One of the Junior SQL Server DBAs in my company approached me yesterday with a dilemma.