Question when altering columns contents in SQL 2000 & SQL 2005
Posted on 2011-09-26
We are changing master ID codes for security purposes. However, some tables are giving the errors below:
Msg 4406, Level 16, State 1, Line 1
Update or insert of view or function 'DS10123' failed because it contains a derived or constant field.
(519 row(s) affected)
Msg 2601, Level 14, State 1, Line 1
Cannot insert duplicate key row in object 'dbo.xx_acctcode' with unique index 'XAKxx_acctcode'.
The statement has been terminated.
We would like to know what do they refer to
Note: we running SQL 2000/2005