johnatpebble
Programmer
Hi,
I'm trying to implement a trigger on a SQL 2005 DB that runs as a mirror of an external application over which I have no control. I need to run the trigger because this DB doesn't store insert and update timestamps which I need to efficiently synchronise with the data (trigger on insert and update puts timestamp into field).
This process causes the [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.
As the app is external I don't think I can use MARS as I can't influence the connection.
Is there any other way to implement this methodology?
Thanks
John
I'm trying to implement a trigger on a SQL 2005 DB that runs as a mirror of an external application over which I have no control. I need to run the trigger because this DB doesn't store insert and update timestamps which I need to efficiently synchronise with the data (trigger on insert and update puts timestamp into field).
This process causes the [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt.
As the app is external I don't think I can use MARS as I can't influence the connection.
Is there any other way to implement this methodology?
Thanks
John