I knew I forgot something. The stats update. VERY IMPORTANT when upgrading from SQL 2000 to either 2k5 or 2k8.

Thanks for the reminder, Gail.

ravikanth - Reasons why you don't want...

I haven't done migration to 2008 yet. However, from what I understand, the engine hasn't changed very much and 2008 supposedly allows a direct upgrade from 2000.

Look into Microsoft's SQL...

Cool! Glad you figured it out. @=)

I run into the same problem with SSIS when I have a schema definition mismatch. I'd advise checking that first. Make sure to check not only structure but (if applicable)...

Thanks for posting your solution. That's a nice document.

So are you going to force the actual xml file to include the those entity references instead of the &lt and =...

I'm assuming "flat" means that the XML is all on one line with no pretty carriage returns between each data element. Sort of like:

&ltcolumn1&gt2adfad&lt/column1&gt&ltcolumn2&gtadfeoue&lt/column2&gt&ltcolumn3&gtetouen&lt/column3&gt

If that's not what the OP means...

Have you tried right-click to see if a menu with a script option pops up?

SSIS in 2005 supposedly allows for the migration of jobs, logins and maintenance stuff, but I've...

I have to agree with Ian here. Replication is not meant as a disaster recovery tool. It's meant to keep data synchronized between separate offices such as bookstores or airlines.

Log...

BTW, have you looked into Data Mirroring? That might stand you in better stead.

What about passive / active clustering with RAID 5 or RAID 10? That is probably the easiest...

Regarding #1, Server A becomes the backup once it becomes available again. Don't try to transfer. It's too much work. Just re-snapshot the database(s) in question and restart Replication using...

A few things to remember:

Make a checklist. -- We can't give you a specific one because it depends on how your server is setup. The checklist should include EVERYTHING...

Ditto, ditto, ditto. Reboots are EVIL (unless your server is totally screwed already or you're doing a software update that requires it).

Ask your hosted team why they've implemented that policy....

Ah, yes. The great SAN debate.

SANs can be wonderful things. We use them in our environment because we have clustered servers. However, the IO issue is well known and...

Your question is too vague. Nobody will answer if they don't know exactly what you're looking for. Also, the question makes it sound as if you want people to do...

I'm pretty sure you can change the default namespace, but you'd have to play with it to be positive.

Why don't you test it out and publish an article on your...