June 6, 2012

sp_MSuselightweightreplication (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


sys.sp_MSuselightweightreplication(nvarchar @publisher
, nvarchar @publisher_db
, nvarchar @publication)


 create procedure sys.sp_MSuselightweightreplication  
@publisher sysname,
@publisher_db sysname,
@publication sysname,
@lightweight int output
-- Check for dbo permission
declare @retcode int
exec @retcode=sys.sp_MSreplcheck_subscribe
if @retcode<>0 or @@ERROR<>0
return (1)

set @lightweight= sys.fn_MSuselightweightreplication (@publisher, @publisher_db, @publication, null, null, null, null)

No comments:

Post a Comment

Total Pageviews