How to hide Caution: Changing any part of an object name could break scripts and stored procedures
Unfortunately, this message cannot be suppressed.*
There was a Microsoft Connect ticket submitted by our very own Aaron Bertrand, but it was closed as won't fix.
Keep in mind that this message isn't an error - it's not even a warning - it's just a cautionary message saying, "Be careful."
*Okay, it can be suppressed, but it involves modifying the source code of sp_rename
, which is not recommended.