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

Have you tried googling for XML escape characters?

How are you importing the XML into SQL Server? Via SSIS or another method?

Sunil,

In the future, please start a new topic with your question rather than piggy-backing off another thread.

SSIS is the best way to load an XML file into SQL server in...

If there's a way to do that, yes.

But if another of the SQL Tools does Gantt Charts (besides Project), I'd like to do that too.

Ahh. I think everyone misunderstands my problem. I have my code. I also have job duration from a JobsMonitoring job we have. Now, I just need to translate my code...

Thanks, Everyone. Sorry I couldn't reply sooner. I was out on vacation.

What I'm working on is a Weekly chart that shows what day of the week & time that the...

Lowell had it right. Apparently, way back when I was switching contract jobs on almost a daily basis, I must have registered and totally forgotten about it.

Steve is frying...