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...

I don't think so. I'm pretty sure the FOR XML..., ROOT command is brand new with SQL 2005.

Sorry.

I'm not sure I understand the problem. Are you saying you want to load nulls but can't or that the data doesn't appear to be loading at all?

ucbus 92278 (10/20/2009)I have tried to use "FOR XML" tag by creating a view of the data, However this resulted in multiple rows in a FLAT structure. To get the...