April 30, 2012

sp_helpreplicationoption (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_helpreplicationoption(nvarchar @optname)

MetaData:

   
create procedure sys.sp_helpreplicationoption (
@optname sysname = NULL
)
AS
DECLARE @optbit bit
DECLARE @retcode int


IF @optname IS NOT NULL AND LOWER(@optname collate SQL_Latin1_General_CP1_CS_AS) NOT IN ('transactional','merge')
BEGIN
RAISERROR(21014, 16, -1)
GOTO FAILURE
END
SELECT optname, value, major_version, minor_version, revision
FROM master.dbo.MSreplication_options
WHERE
optname = @optname OR
@optname = NULL

RETURN(0)

FAILURE:
RETURN(1)

No comments:

Post a Comment

Total Pageviews