I have a table representing users. When a user is deleted I get:

DELETE statement conflicted with the REFERENCE constraint

Apparently, CASCADE DELETE is not as easy as I imagined in SQL Server, and the option needs to be added to the table.

The problem is: I cannot figure out how to add the CASCADE DELETE option.

I'm using: SQL Server 2008. Any ideas how to do this?

sql sql-server sql-server-2008 cascading-deletes
Edit
Report