index on date.

Very nice.

You can attach these to a SQL Server instance (dev, express) and then look at them. It will rebuild the log files.

Don't see a way to do it. I'll forward along.

Steve

No that I know of. You can set auto-close on databases you suspect are not being used and they'll close and log a message in the error log if they...

I've worked with data in both ways and I'd argue you've created a maintenance headache. Separating out data, restoring a customer, moving data if a customer needs their own server...

If Table1 and Sproc1 are owned by the same person, you only grant EXECUTE and it will work. The permissions transfer.

Once you cross databases, the ownership doesn't necessarily transfer. You...

Very interesting responses and quite a variety of opinions.

I have to say I think Andy Leonard has put it better than I did, Thanks Andy!

I think it comes down to...

Strangely enough, the answer returns in the error message.

We re-run older, popular articles at times. With nearly 200,000 people joining the site in the last year, it's not "old" to them, it's likely the first time they saw...

It depends, which isn't a great answer, but here's what I've done.

If I can afford the space, a weeks' worth of backups (full, diff, and logs).

Often space is an issue,...

As many people have answered, you have to get on the ground at the new office and start looking over the environment. I'd ask for resources to get going.

On the...

Things could be out of sync here. An index rebuild/statistics update should fix things.

They should, and I'll take a look.

The instance does not need to be restarted at all. That's overkill. The next comment issued by the connection will have the limits enforced.

The reconfigure is needed, but you...