Look for an insert trigger on the affected table which is blocking the insert.

I work more with Sybase, the close cousin of SQL Server. Sybase also bases the dependencies on object_id unless the id is missing. It then uses the object name. So...