Matt - I should also add that I can take the exact same trigger code, add it to a different table in the same database, have the client app fire...

Hi Matt,

Thanks for the reply.

I've found that any database operation in my trigger causes this lock. I've tried something as simple as SELECT TOP 1 * FROM SysObjects, just...