jana
asked on
Question when altering columns contents in SQL 2000 & SQL 2005
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you, yes!!! We'll do!!
ASKER
Thanx
ASKER
In the" 'dbo.xx_acctcode' with unique index", it could be that the statement is trying top pass it twice. We are using CHECKSUM to change the Master Account ID and it may be that the hash value length is greater than the Master Account ID length; hence, by saving it, it's saving a truncated value upto the columns lenghth, which may be giving the error (since another truncated hash value my be causing it).