Thank you so much, Dan Collier. I got it now!:

Thank you so much for your help!

Thanks for reply. I use DBCC and fixed the problem. but some data lost. how do u know when the table will be corrupted? Thanks.

Hi,

thanks for interest my problem. the service is set up to run under that user account and i don't change the password or don't deleted that user...

Hello,

where can i find the domain policy restrictions pls? could you explain me a little detail?

Hi..

i'm sure the startup type is set to automatic because i run sql server everyday! but today it can't. pls help.

That's Great. Thanks you so much for your help. Your advice is suitable for my problem.

Thanks for reply me. I don't want to use Profiler. I want to use Trigger instead. And then I want to store the sql statement executed by user into the...

I used Trigger Event. But I didn't know which event (update/delete/insert) triggered. That' why if I check the query statement like the 'Trace Text Data', I'll know that exactly. Or...