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_helppeerrequests(nvarchar @publication, nvarchar @description)
MetaData:
create procedure sys.sp_helppeerrequests
(
@publication sysname,
@description nvarchar(4000) = '%'
)
as
begin
declare @retcode int
-- Security Check
exec @retcode = sys.sp_MSreplcheck_publish
if @@error <> 0 or @retcode <> 0
begin
return 1
end
-- Check to see if database is activated for publication
if sys.fn_MSrepl_istranpublished(db_name(),0) <> 1
begin
RAISERROR (14013, 16, -1)
return 1
end
-- return results
select *
from MSpeer_request
where publication = @publication
and isnull(description, N'') like @description
order by sent_date desc
return 0
end
No comments:
Post a Comment