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

Haven't read that one, but I did have one called "Data Modeling" that I read years ago and liked. There's a new one from Eric Johnson and Josh Jones that...

GROUP BY the other fields. I think that will get you where you want to be.

Somewhere there is a default location for data and log files.

No worries, after you've installed it, you can change this. Right click server, properties, database properties. You can choose...