May 15, 2012

sp_MSget_repl_error (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_MSget_repl_error(int @id)

MetaData:

 create procedure sys.sp_MSget_repl_error   
(
@id int
)
as
begin
set nocount on
--
-- 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
select source_type_id, source_name, error_code, error_text,
sys.fn_replformatdatetime(time),
error_type_id,
'has_xact_seqno' = case when xact_seqno is null or xact_seqno = 0x0
then convert(bit, 0) else convert(bit, 1) end,
xact_seqno, command_id
from dbo.MSrepl_errors
where
id = @id and
-- rows with error_type_id are placeholders
error_type_id IS NOT NULL
order by time ASC
end

No comments:

Post a Comment

Total Pageviews