Are relationships the same in Access and SQL Server 2000?

Relationships in SQL Server 2000 are not flexible as they are in Access.

In Jet database:

   1. You can cascade/update and(or) delete/update from a table to itself;

   2. You can cascade/update and(or) delete/update foreign key in a table where Required property set to Yes.

These two options are not supported by SQL Server.