What is the prefered method to do cascading updates and deletes in a SQL Server database? Are they best done with triggers, stored procedures, or is there some database setting to tell the database to perform cascading deletes over the whole system?