July 20, 2009 at 4:09 pm
Hi There can you help me?
I have a linked server set up and a trigger at the same time
Inside the trigger you will find this code
DELETE FROM [ACDB].[Linkedable703].[dbo].ac_CategoryParents
WHERE categoryid in
(SELECT categoryid
FROM [ACDB].[Linkedable703].[dbo].ac_Categories c
INNER JOIN inserted i
on i.cntID = c.intVCCategoryID)
but the weird part is their is no other trigger in the other database that will be trigger back to the first database that can caused transaction context is in used byt another session
But this line of code cause the that error.
any help?
Thanks
July 20, 2009 at 4:14 pm
What error?
And how many rows are in [ACDB].[Linkedable703].[dbo].ac_Categories?
If it is very many you are incurring a HUGE penalty every time the trigger is called.
CEWII
July 20, 2009 at 4:53 pm
The error is transaction Context is used by another session....
July 21, 2009 at 9:34 pm
Create a second connection to the same server/database and use it. I'm guessing that will solve it..
CEWII
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply