April 18, 2012

sp_dropdynamicsnapshot_job (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_dropdynamicsnapshot_job(nvarchar @publication
, nvarchar @dynamic_snapshot_jobname
, uniqueidentifier @dynamic_snapshot_jobid
, bit @ignore_distributor)

MetaData:

 create procedure sys.sp_dropdynamicsnapshot_job (  
@publication sysname,
@dynamic_snapshot_jobname sysname = '%',
@dynamic_snapshot_jobid uniqueidentifier = null,
@ignore_distributor bit = 0
)
AS
declare @retcode int
exec @retcode = sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0
return (1)
exec @retcode = sys.sp_MSdropmergedynamicsnapshotjob
@publication,
@dynamic_snapshot_jobname,
@dynamic_snapshot_jobid,
@ignore_distributor
return @retcode

No comments:

Post a Comment

Total Pageviews