Please do no cross post.

Discussed here: http://www.sqlservercentral.com/Forums/Topic545595-146-1.aspx

You can look at sp_who2 and check the CPU time for xx length of queries.

Up to you. I think you could script an FTP send, or add an SSIS package with the FTP task to send files, but it could easily flake out. If...

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