April 30, 2012

sp_identitycolumnforreplication (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_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

Total Pageviews