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