The meta data is from an SQL 2012 Server.
I have posted alot more, find the whole list here.
Goto Definition or MetaData
Definition:
sys.sp_MSrepl_setNFR(nvarchar @schema, nvarchar @object_name)
MetaData:
CREATE PROCEDURE sys.sp_MSrepl_setNFR ( @schema sysname, @object_name sysname ) AS BEGIN DECLARE @retcode int, @fkid int -- security check for subscriber EXEC @retcode = sys.sp_MSreplcheck_subscribe IF @@ERROR <> 0 OR @retcode <> 0 BEGIN RETURN 1 END DECLARE #hForeignKeys CURSOR LOCAL FAST_FORWARD FOR SELECT object_id FROM sys.foreign_keys WHERE is_not_for_replication = 0 AND referenced_object_id = OBJECT_ID(QUOTENAME(@schema) + '.' + QUOTENAME(@object_name)) ORDER BY object_id OPEN #hForeignKeys FETCH #hForeignKeys INTO @fkid WHILE @@FETCH_STATUS != -1 BEGIN EXEC %%Object(ID = @fkid).SetConstraintNotForRepl(Value = 1) IF @@ERROR <> 0 RETURN 1 FETCH #hForeignKeys INTO @fkid END CLOSE #hForeignKeys RETURN 0 END
No comments:
Post a Comment