Sorry, how do I check to see if histroy is full? Thanks.

Never mind, the entry was a default value.

No, the data looks fine. I select * from the whole table and the data in first_middle is fine. Thanks.

I am not sure what you mean by "user collections". Can you please specify? Thank you.

There must have been some replication done before, and dropped. After I removed the subscriber, I was able to drop the linked server and recreate it. Thanks for...

I ran the sp_helpserver query and the server shows up (even though it doesn't show up in EM). I tried deleting it as you told me and I get...

I think you can use the server name in the select if you have a linked server, I just tried it and it worked. If you can use it...

Sorry, I should have specified what is what. DPLADS01/DPLADS03 are the names of the servers. PEOPLEPC and EARTHLINK are the databases on each server. I hope this...

I want the size of the table. Thanks.

We are using TCP/IP, sql login, the server is not behind a firewall, and it can be pinged. Thanks.

Thank you, that fixed it.

Thank you everyone for your help and quick response!

We are running SQL 2000 S2.

I created it in EM with "Server Type" of Sql Server, remote login username and password, and under Option Name, "Data Access", RPC, and "RPC...

I have tried using QA and get the same error message.

I tried deleting this link immediately after creating it so it was not being used by anyone.

Its very odd.

Hi, I closed down EM and also restarted the service and the server and it still didn't help. I get the same error.