Deleting entry in SQL Server 2005 - Conversion failed when converting varchar value to data type int

Question

I'm manually editing a table in SQL Server 2005 and am trying to delete a single record, but I keep getting the following error:

Conversion failed when converting the varchar value 'D' to data type int

None of the columns, int or otherwise contain the value 'D', so I'm very confused by this. I've checked all the tables in the DB where this entry's Primary Key is a Foreign Key, but nothing there either.

Any suggestions?

Answer 1

Sounds like there may be a trigger defined on this table - probably some form of auditing.

(I'd guess an audit trigger, since I'm guessing it's trying to insert a row in another table with a D to indicate deletion, but I'm also guessing the table definition has changed and the column is now an int column).