Using sp_rename

In my previous post I talked about using sp_rename to rename columns and primary keys/indexes. There was a time when most people recommended that you don’t use sp_rename and if you do a internet search for sp_rename you will see articles such as this one that Andras wrote back in 2006. Things do move on, so when you find a recommendation like this, I would recommend that check that it still applies to the version of SQL Server you are using. You may also find that an article does not explain the whole reason or be vague on the consequences. For example why is it so important that the procedure text held in syscomments so important? If SSMS has a work around when scripting or modifying a procedure, what other problems could it cause? Certain tools may use the text in syscomments to compare two versions of a procedure, but then I would ask if/why such tools should were being used production systems? Surely the definitive stored procedure/view definitions are the ones in version control?

Read more: Martin Bell UK SQL Server MVP

Posted via email from .NET Info