01-24-07 06: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.
[ Post a follow-up to this message ]
|