Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Trigger & Insert

Author  Topic 

vladimir_grigoro
Yak Posting Veteran

62 Posts

Posted - 2002-03-18 : 06:14:42
I have a trigger, which fires on an INSERT statement. The trigger calls COM object, who perform various checks and have to insert the result in the same table. Unfortunately the two processes perform a block (between first and second INSERT statement).

Is there any way to solve this problem?

Thanks in advance.

The Rebel

setbasedisthetruepath
Used SQL Salesman

992 Posts

Posted - 2002-03-18 : 16:16:08
look up "bound connections" in BOL.

setBasedIsTheTruepath
<O>
Go to Top of Page
   

- Advertisement -