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_create_plan_guide_from_handle(nvarchar @name, varbinary @plan_handle
, int @statement_start_offset)
MetaData:
create procedure sys.sp_create_plan_guide_from_handle @name sysname, @plan_handle varbinary(64), @statement_start_offset int = NULL as BEGIN TRANSACTION EXEC %%PlanGuide(Name = @name).CreateAndFireTriggerFromCache(Value = @name, Value = @plan_handle, Value = @statement_start_offset) COMMIT TRANSACTION
No comments:
Post a Comment