Adding a trigger on a profile table
Web Server forum
Back To The Forum Home!Search!Private Messaging System

Web Server Talk Web Server Talk > Web Servers reviews > Microsoft Commerce Server > Commerce Server General > Adding a trigger on a profile table




  Last Thread   Next Thread Next
  Show Printable Version Email this Page Subscribe to this Thread      Post New Thread    Post A Reply      

    Adding a trigger on a profile table  
Bike


View Ip Address Report This Message To A Moderator Edit/Delete Message


 
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 ]



    Sponsored Links  




 





   All times are GMT. The time now is 02:25 AM.      Post New Thread    Post A Reply      
  Last Thread   Next Thread Next


Most Popular forums 

Forum Jump:
Rate This Thread:

Forum Rules:
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is OFF
vB code is ON
Smilies are ON
[IMG] code is OFF
 
Medical and Health forum | Computer Games Reviews | Graphics design forum

Back To The Top
Home | Usercp | Faq | Register