Thanks for the input. I'm confused though, if it's poorly designed or lack of proper indexes, why does it work perfectly for a few weeks then suddenly slows down.

Thanks,

Mon

Thanks Steve, I set the database to Auto-close. Could you tell me what events to capture in the trace? I was looking at Security Audit and then Audit Login/Logout?

Thanks,

Mon

I mean, ran a query or logged into the database. The trace will show me any future usage, is there anyway I can trace what happened in the last couple...

Thanks everyone!

Yikes...thanks!

I am logging in as myself and I am in the sysadmin role. I tried logging in as sa and still got the same error message.

Yes, I can open them using notepad.

Thanks John. I just tried that and still getting the error message.

Thanks for the script. I will try it out. The log file is small.