Here's an odd one. I have two databases, Uploadserver and Uploadtestnew. Both are identical, same tables, same data, same triggers, same users with same rights, same roles, etc. Uploadtestnew is obviously a testing area. I have a trigger on a table in Uploadserver which assigns a policy number as a new record is added to that table. Works fine in Uploadserver, but does NOT work at all in Uploadtestnew. Suggestions?

Marie