Disable Foreign Key for Current Session

Question

I know how to disable a Foreign Key.
My question is, can a foreign key be disabled for only the current session and still have it enforced for other users?
The simplified reason being, that it is a 2 column key, and I need to update some of the key columns in both tables. Cascade update would not suffice.

Answer 1

That's not possible. If a foreign key is disabled, it is disabled for all sessions.
If possible, your best choice might be to do your updates during a time when no other updates are being done.
Another possibility might be to create a trigger that enforces the foreign key but code the trigger to allow foreign key violations for that particular session. Then disable the foreign key. Do your updates, re-enable the foreign key, and then drop the trigger.

Tom