Uh, that's not exactly true. It's true that you can't do cascading deletes via a foreign key constraint, but you can do it via triggers.
I just browsed through the Books Online for SQL Server 7 and I can't find anything indicating that's it's any different in v7. Sorry.
>Hi,
>
>I can't seem to find any information from Microsoft as to whether SQL Server 7.0 performs cascading deletes (I know that 6.5 doesn't which is extremely lame).
>
>Can anyone direct me to a source which documents this?
>
>I posted this message on the SQL Server forum but there's nobody there!
>
>Thanks!
>
>-JT
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams
