Great job Phil!

I've got something similar in the works, or maybe I've published one. Can't remember now, but pulling the plug is tough.

What's crazy is that if you can't salvage...

You could write a VBS script to do this using the object model. Don't have one handy, but search for one. Might be something at sqldts.com

If you're really concerned, give it a long, one-time password that you don't write down. Randomly bang on 20 keys to get it.

Don't rename it or delete it. You'll get...

I'd say Ben-Gan's Inside SQL is a must for 2005.

The others are good, and any of the admin books will work.

correct, if it's the first proc, you can ignore exec, but as a matter of practice: Use it.

This will work as well:

use master

go

sp_detach_db 'konfig'

go

sp_detach_db 'ndfi'

But do this:

use master

go

exec sp_detach_db...

Tend to agree with Michael. Monitor and observe the system. AWE isn't needed for 64-bit and my guess is SQL will keep building cache and run to 30GB unless you...

I've seen chiropractors for pinched nerves. Gave me short term relief, not much long term help. Acupuncture worked better for me.

Try what you like, find something that works, keep your...

Date formats are stored in a binary format, your client interprets that.

Look at CONVERT for the codes and formatting needed to get the dates into particular varchar formats.

I'm confused. Are you getting one warm standby for multiple primaries?

I like VMWare, but keep in mind you'd take a decent sized IO hit here as well as resource loss....

I think you need two nodes to add those things. The other node could be a virtual server, which is what I'd recommend. Or rather, two virtual servers that are...

We do announce things periodically and this is more of a question that rewards those long time members rather than is a learning experience.

Not sure when we'll go to 2008....

Tend to agree with you above. Don't install something you don't need.

I think this is a RAC competitor, just like Scalable Shared Databases or replicating to slaves.

Log shipping existed in many installations before Microsoft built a support solution, this might end...

SP2 had some issues, notably Maintenance plans. I'd go to Cumulative update 2 or 3 at least.

This sounds like homework.

Please post these as separate items, and not as a poll. Use the Add Topic button.

Also, do some research. Explain what you're trying to do and show...