It depends. You said that there are couple of DBs on the old server. Is it being used quite a bit? If not, you dont have to remove the DB....

I forgot to welcome Les and Bru... Welcome to THE THREAD. 🙂

I sometimes feel that the thread rules us... We dont rule the thread anymore. It has evolved itself into a controlling being

Check this link out...

http://msdn.microsoft.com/en-us/library/ms151868%28SQL.90%29.aspx

I am not sure if this will help.

Also someone here in SSC had a problem like this. Check the thread out.

http://www.sqlservercentral.com/Forums/Topic765285-291-1.aspx

Is this a named instance?

Is this from a named instance or a default instance?

SQL Server 2008 with Windows 2008 will make a difference because the 2008 OS TCP Stack is much improved. Now the question for you is why Peer to peer? Cant...

Does the User that is running the distribution agent have permission to see the share and read the file?

I think it will be not be a problem to skip the chapter meeting, Coz I will do exactly the same... 🙂 Next year if I make it, I will...

lol... That was nasty...:-P

I am planning to come next year, BUT I dont think I want to scare people by wearing a Kilt next year... :hehe:

Did someone try to have couple friendly bouts of martial arts? If so who kicked whose A**?? 😀

I guess you guys are/had a wonderful time at PASS. 🙂

Thanks for the update Bob. Hopefully I can come next year for the PASS event. I am sure I will gain quiote a bit of knowledge coming for that meeting.

Hey J-F,

Check this thread out. This was an interesting discussion as well regarding the same matter. 🙂