I suppose you could set permissions on the XP. There's a proxy, and that limits rights. Limiting access to master for users (remove from public) might work.

Are you SP2? there was a problem with this in SP2, one of the CUs post SP2 fixes this.

I think the solution above should give you results. Left joins show nulls where something doesn't match.

You need to remove read only status, fix the users, then set it again.

sp_change_users_login

You should be adding indexes to the tables. Are they indexed?

I've heard that you want one tempdb file per core that you have for SQL Server. Not sure if that helps, but I think that separation makes more of a...

I think Andrew has the best idea, otherwise you need a backup.

Lesson one: never alter master without a backup. or any database for that matter.

Typically MS allows you to license the way that is most effective for your company (CPU or CAL) in terms of cost.

Usually CPU is more expensive, so people try...

I don't agree with companies scraping this information, though I'm not sure they're wrong, either in the moral or legal sense. You put it out there and allowing someone to...

Of course! Likely you'll find a faster way, but hey, that's why we love (and quote) you!

Why? I believe if you have Enterprise licensed, you can have as many instances as you want of it on a machine. Wouldn't make sense to install Standard on there.

I'm not sure if this will work, but if you open the trace in Profiler 2005, I'd guess it would.

The trace is a series of statements and the replay just...

Yep, just like parenting. Treat them all different under the same rules. They earn and lose privileges, just like my kids. Give them rope, let them learn responsibilty, and hopefully...

We need whistleblower protections and more media outlets to report on government. As long as you're not endangering lives or national security, which needs to be proven in the courts,...

There will always be issues and we need to respond to them, but how to we disclose the info?

Not sure you should know the guy's name from Best Buy. What...