June 6, 2012

sp_publishdb (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_publishdb(nvarchar @dbname
, nvarchar @value)

MetaData:

   
-- For backward compatible --
create procedure sys.sp_publishdb @dbname sysname,@value nvarchar (5)
AS

DECLARE @retcode int

EXECUTE @retcode = sys.sp_replicationdboption @dbname, 'publish', @value

IF @@ERROR <> 0 or @retcode <> 0
BEGIN
RETURN (1)
END

RETURN(0)

No comments:

Post a Comment

Total Pageviews