Hi again.

Is there any chance that IM_SUBITEM has an UPDATE trigger itself that updates the OLEINXFR table?

That would mean a recursive trigger exists and could explain what is happening.

- Mike

...

Hi Beth.

This certainly seems strange.

Have you tried reversing the order of the UPDATE statements within the trigger to see what happens?

Another idea would be to split these into separate triggers...

Hi Kevin.

Well, I sorted out my problem connecting to the remote workstation running SQL Server Personal Edition from another workstation.

Before I explain the problem, many thanks for your ideas and...

Hi Steve.

Sure, I can do this. Is there a procedure for submitting articles?

- Mike

Thanks for the tips, Kevin.

Here are my responses to your ideas.

Using OSQL -L, the remote workstation shows up in the list but I cannot actually connect to it via OSQL....

Hello. Thanks for the response.

I am trying to connect via Enterprise Manager. I have also tried Query Analyzer.

I have tried both methods (i.e. the computer name AND the fully qualified...

Thank you for the responses Allen. Unfortunately, I was hoping for more information than what you provided.

#1 - CD install directories.

No need to cut & paste from BOL. I have...