I have a linked server and I'm having a tough time referencing it properly.<BR><BR>If I open SQL Management Studio and run a query on the server itself it works great.<BR><BR>However, I want to ...

We use linked servers in SQL Server 2000 (I know...) to pump data from an AS400 running DB2 in to some tables in SQL Server to do analysis. It is realy painful as the source system is a Danish ERP ...