Mathew,

Thanks for the note, and I think you have a good business. 37 Signals does business like this, and I think there is some good value for many companies...

A couple things.

First, can you post the backup command?

Second, does this run interactively? If you run from SSMS?

Last, backups to remove drives (shares) are problematic, and flaky. The backup process...

It's harder to maintain things as they grow, and this is a good example. BOL is built by a team, and my guess is someone copied the documentation from 2005,...

TheSQLGuru has the advice I would give. You need to determine where your space is being taken up. We can't help you until you determine if this is an audit...

You can remove the guest user. DO NOT remove the others.

AFAIK, George has the correct steps to get this working again.

Pending a definitive answer, I have left things alone for now.

Once I have one, I'll adjust the question and account for 64bit as well, which just lists 50 instances.

Good job on the series, David!

You have duplicates, but why not a straight update if you don't have them?

update Person

set postto = orgid

from functionofperson

where functionofperson.pid = person.pid

No need for a subquery.

You...

British, French, it's all across the water.

Apologies, Jan. I think I meant to write down there, but slipped up.

Wow, that's pricey considering my WD "green" 1TB drive cost me $142. Granted, it's a touch slower.

Thanks, but I do enjoy what I do. It's not a passion, but I'm not sure what that is for me.

My best days as a technologist as behind me. Not...

Run sp_configure (you might need to enable advanced settings) or check the server properties. c2 Audit more is a configuration setting.

I'm not saying you're wrong, and the MVP program is a nebulous beast, but that doesn't sound like discrimination against you for being a woman. Maybe for other reasons, but...

It is amazing that they're all not 99%. I can see people mis-clicking things, so I'm not sure it will be 100%, but I'm surprised msdb isn't higher.