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_MSupdate_tracer_history(int @tracer_id)MetaData:
-- -- Name: -- sp_MSupdate_tracer_history -- -- Description: -- This procedure will update the tracer history row's distrib_commit -- time to getdate(). -- -- Parameters: -- @tracer_id int Id of the tracer to be updated -- -- Returns: -- 0 - succeeded -- 1 - failed -- -- Result: -- None -- -- Security: -- Sysadmin/dbo (run by logreader only) -- create procedure sys.sp_MSupdate_tracer_history ( @tracer_id int ) as begin set nocount on -- -- security check -- only db_owner can execute this -- if (is_member ('db_owner') != 1) begin raiserror(14260, 16, -1) return (1) end -- update the requested tracer token -- if the tracer token row no longer exists then -- we will exit with no error because this may happen -- if cleanup comes bye and removes the token row update MStracer_tokens set distributor_commit = getdate() where tracer_id = @tracer_id if @@error <> 0 begin return 1 end return 0 end
No comments:
Post a Comment