>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).
SQL Server 7.0's database engine still does not support cascading deletes or updates through DDI. If you need that ability, you'll have to create it procedurely (sp?) using triggers.
-Mike