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.


4
1
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

Description

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