General - Do you know to not use "sp_rename" to rename objects?

Last updated by ChristianMWaite over 4 years ago.See history

Do not use "sp_rename" to rename objects like stored procedures, views and triggers. Object name should be the same as the name used in the object's script (e.g. CREATE script for stored procedures, views and triggers). Inconsistency can happen when object is renamed with sp_rename, but its script is not updated.

Adam Cogan
We open source. Powered by GitHub