Locking issue when triggers are applied
Posted on 2008-06-11
i am using sql 2005 std edition and i have applied a trigger to a table that writes of certain fields to another table as soon as they entered.
i want this second table so i can report of the back of it without the report locking- which happens quite alot on the live table.
The issue is now that due to the trigger i am experiencing quite alot of update locks - lck_m_u, and i am having to use sql manager to kill the locking proccess's !
is there a certain procedure i should have followed to ensure this does not happen?
i am a beginner here so i would appreciate it (if possible) to explain in detail what i should be doing!
thanks in advance!