May 16, 2012

sp_MSgetreplicastate (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_MSgetreplicastate(uniqueidentifier @pubid
, uniqueidentifier @subid)

MetaData:

   
create procedure sys.sp_MSgetreplicastate
@pubid uniqueidentifier,
@subid uniqueidentifier,
@replicastate uniqueidentifier output
as
if ({ fn ISPALUSER(@pubid) } <> 1)
begin
RAISERROR (14126, 11, -1)
return (1)
end

select @replicastate = replicastate from dbo.sysmergesubscriptions
where pubid = @pubid and subid = @subid

return (0)

No comments:

Post a Comment

Total Pageviews