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...

Tripwires have been around for awhile. If you pay attention, every once in awhile trading gets halted.

I want to say some were done after the crash in 85/86 and more...

How do you know which one to keep? The first one? Or the one that has all the fields?

That's important otherwise you could say row 2 duplicates row 1.

Multiple passes...

Have you logged in with the account? It should ask for a new password.

First of all, good for turning off shrink.

Second, the log file is allocated, it doesn't grow like a Word or Excel file. If you need that space for index rebuilds...