I am having an issue deleting a row in SQL Server 2008 because of a primary key constraint:

> 
> *The DELETE statement conflicted with the REFERENCE constraint...*
> 
> 
> 

Is there any way I can have the conflicting primary key displayed in the error message?