You didn't specify the service pack on the XP box, but if it's XP2, you'll likely need to do the following:

How to enable MSDTC communications with...

I recreated the test and was able to write successfully. Basically I outputted the contents of the Orders table from Northwind to a text file. Was able to INSERT and...

I wasn't speaking about me being a god of the site. I meant Steve, Andy, and Brian Knight, who were working on the icons.

Oh yeah, note the avatar change.

Andy Warren and Brian Knight have the same capabilities as they are part owners of SQLServerCentral.com. However, Steve is on full-time at SSC because the site has grown to where...

It's been a long time since I tested (2003, I think), but I believe the answer is yes on the inserts. I don't think I tried updates and deletes. I...

Thou shalt not anger the real gods of the site.

You can create a linked server connection to a text file using Jet. That's one way to do it without resorting to xp_cmdshell.

Jet OLE DB Provider...

True, it is for moderators as we were the guinea pigs. Under the old messageboards we had the ability to edit, delete, and lock posts. That functionality isn't available in...

I read the original thread. Yeah, I think he was clearly crossing the line. English not being your first language is no excuse for taunting, which he was doing.

I...

I was a guinea pig of Steve and Andy as they were transitioning to the messageboards. Somewhere along the line I get the graphic under my name. I like it...

If I remember, right, though, doesn't this generate a sev 16 error if the linked server is unavailable (meaning it drops out of the batch and doesn't run anything else)....

The problem is there are users in the database at the time of the restore. The user could even be you. Make sure you're not in the database at the...

The maintenance plan is running a DBCC CHECKDB() for the integrity check. What you would need to do is replace the job that does the Integrity check through the maintenance...

8.00.2039 is the SQL Server version for SP4, yes. If you see that it should mean you have SP4 applied to your SQL Server.

Sounds like you're going to need to write a script using WSH. That's outside the bounds of this site, but here are some things you can do.

1) Node currently working

Do...