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.


16
0
Sign in
to vote
ID 266048 Comments
Status Closed Workarounds
Type Suggestion Repros 5
Opened 3/29/2007 11:11:34 AM
Access Restriction Public

Description

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
Hi,
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