May 8, 2012

sp_MScheckexistsrecguid (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_MScheckexistsrecguid(uniqueidentifier @recguid)

MetaData:

 create procedure sys.sp_MScheckexistsrecguid  
@recguid uniqueidentifier,
@exists bit output
as
declare @retcode int

exec @retcode = sys.sp_MSreplcheck_subscribe
if @retcode <> 0 or @@error <> 0 return 1

if exists (select * from dbo.sysmergesubscriptions where recguid=@recguid)
begin
set @exists= 1
end
else
begin
set @exists= 0
end

return 0

No comments:

Post a Comment

Total Pageviews