I receive the following error (taken from replication monitor):
The option 'FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME' is only valid when used on a FileTable. Remove the option from the statement. (Source: MSSQLServer, Error number: 33411)
The command attempted is:
CREATE TABLE [dbo].[WP_CashCenter_StreamLocationLink]( [id] [bigint] NOT NULL, [Stream_id] [int] NOT NULL, [Location_id] [numeric](15, 0) NOT NULL, [UID] [uniqueidentifier] NOT NULL ) WITH ( FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAME=[UC_StreamLocation] )
Now, for me there's two things unclear here.
-
Table already existed on subscriber, and I've set
@pre_creation_cmd = N'delete'for the article. So I don't expect the table to be dropped and re-created. In fact, table still exists on subscriber side, althoughcreate tablecommand failed to complete. What am I missing? Where does thiscreate tablecommand come from and why? -
I don't understand why does this
FILETABLE_STREAMID_UNIQUE_CONSTRAINT_NAMEoption appear in creation script. I tried generatingcreate tablescript from table in SSMS and indeed, it's there. But what's weird, I can't drop and re-create the table this way - I get the very same error message.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire