Correct. This is hyperthreading. The SQL Server Central.com boxes are 2 way, but show up as 4. There's been some debate as to whether or not hyperthreading is bad for...

Not that I know of. I know when I've need SQL to pick up a new IP, I usually have to restart.

I saw this at a deonstration byu DB Assciates (now Imceda) years ago. It's one of the reasons all the backup products include encryption capabilities.

I thought about including that one, but then everyone would pick it and then all you great DBAs would be looking for new jobs when your manager gave the junior...

From the lead storage engine developer: Table variables are materialized in tempdb.

I thought they were in memory as well until a couple weeks ago.

Wasn't us and there has been some question. In speaking with the storage engine devlopers at TechEd they said there isn't a big difference between them. Some restrictions on table...

I definiteley agree with access to resources. At least the tools that come with the product if not the Internet.

I don't think that you can do this. You can run Profiler and capture only the failed logins. I think that will get the hostname in it if submitted.

Please don't cross post and call Microsoft for this one.

You probably need to call Microsoft to interpert the dump.

I don't think there is anyhting you can decode without them.

Ditto here. Script them, do a search and replace if needed for servername, and run the script on the nwe server.

Are you using Enterprise Manager or QA and TSQL? Enterprise Manager sometimes doesn't work, but sp_dropuser should.

I wish it were baseball, but I'm starting to think American Football is the game here. Never played lacrosse, but it is getting big here, I might have to get...

Lacrosse? You're kidding.

BTW, what's the US national sport?

The safe storing is a good idea and one I've used in smaller companies. Give a sealed envelope to the CFO/Accountant to store. That way if I disappear, he can...