May 25, 2012

sp_MSrepl_setNFR (Transact-SQL MetaData) Definition

Please note: that the following source code is provided and copyrighted by Microsoft and is for educational purpose only.
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

Total Pageviews