sp_rename and stored procedures

Question

sp_rename and stored procedures

Thomas Franz

Hall of Fame

Points: 3897
More actions
September 24, 2018 at 12:01 am

#377725

Comments posted to this topic are about the item sp_rename and stored procedures
God is real, unless declared integer.

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

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

Shayn Thomas SSCertifiable Points: 5863 More actions · Answer 1

nice question to test the old noodle today 🙂
Cheers

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

Kaye Cahs SSCarpal Tunnel Points: 4135 More actions · Answer 2

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

webrunner SSC-Dedicated Points: 31885 More actions · Answer 3

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

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 4

Nice question,thanks Thomas

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

Jeff Moden SSC Guru Points: 1004412 More actions · Answer 5

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)