Hi Jack,

I am exactly looking for this solution, Thank you very much.

But when I run the update query concurrently from different threads, I am getting exception as "Transaction (Process ID...

Thank you for your quick reply.

request you to provide some hints or some information , using which i can update my trigger to meet business requirement.z

requesting you for some...

Hi Andrew,

Thanks for your reply ..

same behaviour for one /multiple inserts from application .

- fourthcolumn(ntext) which contains chat history and this is encrypted before it loads into table...