Commerce Server General - Adding a trigger on a profile table

Author

Adding a trigger on a profile table

Bike

2007-01-24, 1:39 am

Greetings

I created a trigger on OrganizationObject table that updates data in another
database on the same SQL server. I made sure that permissions on the other
database are correct, I tested the trigger by running queries against the
table in query window using the same user that commerce profile system
runtime uses, and it ran without a problem. When i update a profile I get
the following error

"Multiple-step OLE DB operation generated errors. Check each OLE DB status
value, if available. No work was done"

I tried to run SQL Profiler to see the error, the error column is always 0 -
OK when the update statement runs. So I cannot determine the cause of the
error message.

Thanks a lot in advance.