Home Dashboard Directory Help

sp_rename : suppress "caution" warning message by AaronBertrand


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 266048
Opened: 3/29/2007 11:11:34 AM
Access Restriction: Public


sp_rename currently has a warning message that cannot be turned off. I would have expected SET ANSI_WARNINGS OFF to prevent this warning from appearing, but it does not:

"Caution: Changing any part of an object name could break scripts and stored procedures."

The reason this has been a problem for me is that it fills up all of the visibile history in the SQL Agent log, and makes any *real* error messages go out of scope (because only so many characters are held in the log).

I have worked around this by using a round-robin schema swap, but it makes deployments much more complicated, and affects performance, because the statistics go with the object when you move it to a different schema...
Sign in to post a comment.
Posted by Microsoft on 12/12/2007 at 4:05 PM
Thanks for your feedback on this. We are investigating this issue about unsupressed warning messages. If thsi turns out to be real defect, we will address this issue in a next release of SQL Server. Please feel free to contact us in case you have any additional feedback/questions on this.

Srini Acharya
Sign in to post a workaround.