Thank you very much, it helps a million.

Cheers,

Thanks for your suggestions...

I have looked around the problem w.r.t triggers, and i found that, the trigger is causing the problem, i have two triggers one is for update and...

I tried with DBCC OPENTRAN, it shows nothing...displays below msg

No active open transactions.

We can also use the below conversion to get the same result.

e.g to get only two digits after decimal for a value 6.0834298900

Select LTRIM(RTRIM(STR(6.0834298900,10,2)))

results in 6.08

Cheers,

Madhava.B