sql server msde: Hi group,

this just drives me mad: I need my msde (the 7.0 version) to deferr
foreign-key checking until commit time.

The problem is this: I need to delete some rows in different tables
from my middle tier. I do not know which rows in which table are
delted beforhand so sorting the statements is impossible.

My idea now was to call "SET CONSTRAINTS ALL DEFERRED" (which is just
plain SQL92) to tell my %$&§ server to wait until every statement has
been executed.

Please, any idea on how to get that to work?

[quoted text, click to view]

[snip]

I found out: This is not supported under SQL-Server. Bad luck