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)
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply