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_MSenum_logreader_sd(nvarchar @name, datetime @time)
MetaData:
create procedure sys.sp_MSenum_logreader_sd
(
@name nvarchar(100),
@time datetime = NULL
)
as
begin
set nocount on
declare @start_time datetime
declare @time_up datetime
--
-- security check
-- only replmonitor can execute this
--
if not (is_member(N'db_owner') = 1 or isnull(is_member(N'replmonitor'),0) = 1)
begin
raiserror(14260, 16, -1)
return (1)
end
IF @time IS NULL
select @time = GETDATE()
--
-- Minute-approximate @time can be used.
-- Note: The select only return datetime data with minute precision
--
IF DATEPART(second, @time) = 0 AND
DATEPART(millisecond, @time) = 0
BEGIN
SELECT @time_up = DATEADD(second, +59, @time)
SELECT @time_up = DATEADD(millisecond, +999, @time)
END
ELSE
SELECT @time_up = @time
select top 1 @start_time = start_time
from MSlogreader_history rh with (READPAST)
where
rh.agent_id = (select top 1 id from MSlogreader_agents where name = @name) and
time <= @time_up and comments not like N'<stats state%'
order by timestamp DESC
select runstatus,
'time' = sys.fn_replformatdatetime(time),
comments,duration, delivery_rate, delivery_latency,
delivery_time, delivered_transactions, delivered_commands, average_commands,
error_id
from MSlogreader_history rh with (READPAST)
where
rh.agent_id = (select top 1 id from MSlogreader_agents where name = @name) and
start_time = @start_time
and comments not like N'<stats state%'
order by timestamp desc
end
No comments:
Post a Comment