May 7, 2012

sp_MSchange_priority (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_MSchange_priority(uniqueidentifier @subid
, nvarchar @value)

MetaData:

 --  @value has to be unicode too.  

create procedure sys.sp_MSchange_priority (@subid uniqueidentifier, @value nvarchar(255))
as
declare @retcode int
exec @retcode = dbo.sp_MSreplcheck_subscribe
if @retcode <> 0 or @@error <> 0
return 1

update dbo.sysmergesubscriptions set priority = convert(real, @value)
where subid = @subid

No comments:

Post a Comment

Total Pageviews