Bogus error messge when altering IDENTITY column when table has a persisted computed column - by Erland Sommarskog

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<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 756654 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 8/2/2012 7:12:22 AM
Access Restriction Public


If you have a table with an IDENTITY column and a persisted computed column, and you try to change the data type of the IDENTITY column, you get an error message that ANSI_WARNINGS has the wrong setting. If you alter some other column or if there is no PERSISTED column, the command succeds.

I would not say that the this a compelling situation that must work, and it may be by design (restriction) that the command fails. However, the error message is incorrect.
Sign in to post a comment.
Posted by Microsoft on 2/26/2013 at 7:14 PM
Thank you for your feedback. We have investigated the issue and the fix will be available in the next release of SQL Server.
Thanks & Regards,
Pooja Harjani
Program Manager
SQL Server