sp_rename : suppress "caution" warning message - by AaronBertrand

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 266048 Comments
Status Closed Workarounds
Type Suggestion Repros 6
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