If you won't need the space, yes, use shrink files, pick the log file.

Be sure you leave space in there for normal operation.

Bob,

I will for sure. I'll shoot for off hours.

Gus, we'll miss you. Next time.

Autoclose will actually write this in the error log for Windows. I don't see a trace event. Maybe capture any t-SQL batch in that db?

I have added the truncate item to the explanation.

My guess is it's the data you're returning.

If you have a loan in a table, say borrower, and you have two borrowers, what do you want done? Only the first...

Should be fine. Glad that worked.

I think that the problem was that you were using that database and when you clicked, it disconnected you. Your session went, and that included...

Hey, if it could kill my SPID, I might be way more productive!!?!? :-D:w00t:

Who has one machine?

If you have one machine, Backup is great.

I think it's you.

If SS2K8 SSMS you can color code your connections so you know which query is connected to which server.

I'm not sure any tool handles the multiple tab...

No, when SQL starts it opens the db and that's it. It doesn't log the activity.

I'd set auto close and check the log periodically. After xx days, detach the...

Maybe I should run this query as a job? kill the user here that uses the most CPU and memory every 5 minutes?

I would agree that killing the most heavily used query is a way to get into trouble. I think what you need to do is identify what the user(s) is...

you might have been connected to that particular database, or it's your default.

Try opening a new query window, connecting to your instance, choosing master as a specific db.

If you did not install SQL Server as a cluster node, you cannot make it a cluster node. You'll have to reinstall it, or install a named instance as a...

I enjoyed Loveland tues, not sure we'll go tomorrow. Things are shaky now, and it's not worth it if the weather is really bad. Worse case I'll get ready for...