April 22, 2012

sp_enableagentoffload (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_enableagentoffload(varbinary @job_id
, nvarchar @offloadserver
, nvarchar @agent_type)

MetaData:

 create procedure sys.sp_enableagentoffload (  
@job_id VARBINARY(16),
@offloadserver sysname = NULL,
@agent_type sysname = NULL -- 'distribution' or 'merge', case insensitive
) AS

SET NOCOUNT ON

RAISERROR(21023, 16, -1, 'sp_enableagentoffload')

RETURN (1)

No comments:

Post a Comment

Total Pageviews