create procedure sys.sp_MSrepl_helptext @procname nvarchar(4000)
as
begin
declare @max_row_number int, @row_number int, @definition nvarchar(max), @objid int
select @objid = object_id(@procname)
if @objid is null
begin
declare @db_name nvarchar(130)
select @db_name = db_name()
raiserror(15009,16, -1, @procname, @db_name)
return 1
end
select @max_row_number = max(colid)
from dbo.syscomments
where id = @objid
select @row_number = 1, @definition = N''
while @row_number <= @max_row_number
begin
select @definition = @definition + text
from dbo.syscomments
where id = @objid
and colid = @row_number
select @row_number = @row_number + 1
end
select @definition
return 0
end