your post got cut off, can you explain what "part" means?

Mark beat me to the response, but I'd agree here. It's a connectivity error. Check the endpoint on the mirror server and verify the port.

Not sure you want to be counting on diesel fuel getting to Summit, Grand, or Eagle if the power goes out 😉

I'm not sure we want to decentralize data centers...

If you can find a log reader for v6.5, not sure who had one then, you can flip through log backups. The version column in sysobjects detected a change in...

We've used templates before, putting them on a shared, standard mapped drive for everyone. It has worked OK, set them to read only, prevent changes, let everyone get to them.

You should never assign permissions to public. Always create another role and assign permissions there.

If you give the user the rights through to the proc, they can access the table....

Why does the user have access to the SP then? That doesn't make sense.

I'd run every 5 minutes for a few weeks, get a baseline across all days.

this is a gray area with MS and you'd be better off just contacting them. They'll answer for free and let you know what they think in your situation.

Start a new thread for each query. Give the query and the indexes on those tables. We'll ask for more data.

Go with your gut on the ones you think are...

The log doesn't hurt anything at 20GB. It might be a bit large, or it might not, depending on the load of your largest transaction.

In any case, I'd run the...

Good comments and I do agree. The initial reporting should be better done, and we strive to try and do a good job here when we announce something.

All we can...

Please, please stop shrinking databases, it doesn't help. Almost never is it worth doing.

This is an interesting question. When is the space released? It's really when are the extents deallocated...

you don't want to change the ownership, who knows what would break.

Rename SA, go with Windows auth only or disable SA from logging in.

For sure, I need to send Best Buy a note. Was browsing in there and while it's nice to be asked if I need help, the 8th time in 30...