June 6, 2012

sp_MSupdatereplicastate (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_MSupdatereplicastate(uniqueidentifier @pubid
, uniqueidentifier @subid
, uniqueidentifier @replicastate)

MetaData:

   
create procedure sys.sp_MSupdatereplicastate
@pubid uniqueidentifier,
@subid uniqueidentifier,
@replicastate uniqueidentifier
as

--
-- Check to see if current publication has permission
--
if ({ fn ISPALUSER(@pubid)} <> 1)
begin
RAISERROR (14126, 11, -1)
return (1)
end

update dbo.sysmergesubscriptions
set replicastate= @replicastate
where pubid = @pubid and subid = @subid

return (0)

No comments:

Post a Comment

Total Pageviews