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