Home Dashboard Directory Help
Search

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


Status: 

Closed
 as Fixed Help for as Fixed


4
1
Sign in
to vote
Type: Bug
ID: 756654
Opened: 8/2/2012 7:12:22 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.