Version Control your Stored Procedures

Question

Version Control your Stored Procedures

Viewing 2 posts - 76 through 76 (of 76 total)

You must be logged in to reply to this topic. Login to reply

Gursoy Yerli Valued Member Points: 51 More actions · Answer 1

Fixed a bug;

Your generation sproc was ignoring the schema when using "EXEC sp_helptext @ProcedureName". Added below to fix the issue.

DECLARE @abc VARCHAR(MAX)

SET @abc = @RoutineSchema + '.' + @ProcedureName

INSERT INTO @StoredProcsDefinitionTable

(

ProcedureLine

)

EXEC sp_helptext @abc

Good article but It does not apply what we're trying to do.

Jonathan AC Roberts SSCoach Points: 18354 More actions · Answer 2

Gursoy Yerli (5/11/2010)
Fixed a bug;
Your generation sproc was ignoring the schema when using "EXEC sp_helptext @ProcedureName". Added below to fix the issue.
DECLARE @abc VARCHAR(MAX)
SET @abc = @RoutineSchema + '.' + @ProcedureName
INSERT INTO @StoredProcsDefinitionTable
(
ProcedureLine
)
EXEC sp_helptext @abc
Good article but It does not apply what we're trying to do.

Thanks, I never spotted that all my sprocs are on [dbo] schema.