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.

I doubt Microsoft discriminated here, more that I think they were trying to cover up poor programming. That would make more sense.

Not that there isn't discrimination. There still is, but...

That may be a profiler thing. I didn't think this was counted as a password since it's a stored procedure parameter.

To be sure I'd ask your network people to...

Bill does a great job of showing those features. I might need to add those to our Question of the Day list!

You can run a trace with Profiler to check this, but I believe this is sent over the network.

You can put this in a stored procedure, which is arguably safer,...

The SQL Server error logs do not require must space. I doubt that those lots are taking up that much space, but check the amount of space in your error...