Thanks for the instant replies. I am absolutely agree with GilaMonster. Some application is doing the deletion and what I have to do is to get some information which application...

Thanks a lot ALZDBA.I really appreciate this.This is exactly what I needed.

Thank you again

Charshman, I really appreciate your suggestions. Thanks a ton.:):)

Thank you.I really appreciate your help.

Thank you all ...I will now try to shrink the database as per your advices..:)

James ,thank you for your information.

Thanks Andreas.It really help me

Verify your authentication mode,if it is Windows authentication then check if you have to provide username and password during login. If not then you can not connect in Windows authentication mode...

This works! Thank you.