How to detect if an entity is in use in SQL Server 2008?

gerdex

New Member
I want to know is there any way to know whether a record is in use with other records. Is there any way to find it other than, by catching referential integrity exception?I generally catch this exception and tell users no to delete or unable to delete the record.
 
Back
Top