• Okei, In Paul Randal's blog, he mentioned for SQL 2005 or behind, they changed the way the trigger working. But I could not find how it works.

    I would really appreciate if you could help me on the same as you said....I would also definitely look and share the same.