Thanks for the suggestions. Dynamic SQL is new to me. I still have been unsuccessfull. I need to read about the code both of you have supplied so I may...

Thanks for the replies! I have a few more questions.

 I've been working on it and I i have a problem converting my @test-2 variable to a value to...

Hmmm, that seems like it was too easy to really be worth posting on this site! Thanks it worked. I was making it way more complicated. Thanks again Chris!!!!!

Ok I wasn't looking for a free ride on this site and have been looking for a solution for awhile (The BOL is big, espescially when you have other things...

No. The rows already exist in the table (35,000 or so) I want to change the date in the already existing rows on the production Order table from the restored...

Sorry for taking so long to reply, the holiday weekend slowed me down  

 I ended up re-adding the server with "local" specified:   sp_addserver 'servername' ,local   ...

I already tried that and stated I did in the first post. I can however connect to this server via QA from other servers.

I take back that I can connect via EM, I just tried it and it doesn't work. It says the connection is broken. Is there somewhere in the registry that...

I backup to three different servers: 1 Full and 7 Trans Logs for 8 hours total to one server then the next two servers have follow the same setup for...

As always thanks for the response. We are a really small network and this jukebox is serving primarily as a paperless system but I have wanted to get my  DB...

Thanks everyone for the replies! Now I've got some more great reading material. I have been tooling around with this all day long and will continue to explore the other options...

Just did. I enabled Network Transactions,Network Adminstration, and Network Clients.

I can establish a connection to this Server with the XP box no problem. The other W2k3 box only connects to it...

Thanks for resonding Cody. I checked that out in Component Services on my New W2k3 Server and it already had NT Authority\networkservice as the login.

I have the problems semi corrected. I can connect to the server now via my XP box internally (TCP/IP or NamedPipes)  but not externally. I have both boxes on the...

Thanks for responding Carl!!

1- I am not getting that error. The error I get when I attempt to register the server (not set up a linked server) is  "SQL Server does...