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_identitycolumnforreplication(int @object_id, bit @value)
MetaData:
--
-- Name:
-- sp_identitycolumnforreplication
--
-- Description:
-- This procedure allows customers to set the NFR on
-- identity columns for a particular table.
--
-- Returns:
-- 0-Success 1-Failure
--
-- Security: DBO check
--
-- Requires Certificate signature for catalog access
--
CREATE PROCEDURE sys.sp_identitycolumnforreplication
(
@object_id int,
@value bit
)
AS
BEGIN
DECLARE @identity_column sysname
IF IS_SRVROLEMEMBER('sysadmin') = 0
AND IS_MEMBER('db_owner') = 0
BEGIN
RAISERROR(21050, 14, -1)
RETURN 1
END
SELECT @identity_column = NULL
SELECT @identity_column = name
FROM sys.columns
WHERE object_id = @object_id
AND COLUMNPROPERTY(object_id, name, 'IsIdentity') = 1
IF @identity_column IS NOT NULL
BEGIN
EXEC %%ColumnEx(ObjectID = @object_id, Name = @identity_column).SetIdentityNotForRepl(Value = @value)
IF @@ERROR <> 0
RETURN 1
END
RETURN 0
END
No comments:
Post a Comment