Posted by ebade2000 on 03/21/07 23:06

Sorry for not specifying extra details, I thought it was a general
issue, I am running MS SQL 2000.

Thanks for your help, I very much prefer method 1. After looking at
your solution, it seemed so obvious. I probably need some rest LOL.

PS: Doesnt make any sense to post the error now but I will incase it
helps someone elses search
Server: Msg 547, Level 16, State 1, Line 1
UPDATE statement conflicted with TABLE REFERENCE constraint
'FK_T2_T1'. The conflict occurred in database 'DB_Test', table 'T2'.
The statement has been terminated.

Server: Msg 547, Level 16, State 1, Line 1
UPDATE statement conflicted with TABLE FOREIGN KEY constraint
'FK_T2_T1'. The conflict occurred in database 'DB_Test', table 'T1'.
The statement has been terminated.

[Back to original message]