Version Control your Stored Procedures

  • 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.

  • 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.

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

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