Thanks Ashish ,

But this is 2005. any way to do the same in 2005 sql server ?

Hi,

Thanks for your responses.

Custom traces have not been enabled. Is there any other way to trace out the exact cause.