sp_rename and stored procedures

  • Comments posted to this topic are about the item sp_rename and stored procedures

    God is real, unless declared integer.

  • nice question to test the old noodle today 🙂
    Cheers

    ---------------------------------------------------------------------------------------
    The more you know, the more you know that you dont know

  • Good question. 
    I should have finished my coffee before I attempted to solve it.

  • Thanks, this was an informative question.

    - webrunner

    -------------------
    A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
    Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html

  • Nice question,thanks Thomas

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”

  • Man... what a way to obfuscate code if you're building some sort of data dictionary from sys.sql_modules.  Although the rename fails to change the stored procedure there, it does change it in the object explorer, as expected.  You've got to wonder why MS stopped short on sys.sql_modules.

    Makes me wonder what they're really executing because if you generate the script from the explorer window, it generates correctly.

    Great question... and, yeah... {hanging head in shame}, I got it wrong. :blush:

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

Viewing 6 posts - 1 through 6 (of 6 total)

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