I have created a linked server in 2005 in the hope I can import data via a simple query:
The local server (2005) is called MAGGIE and the remote server (2000) is called STARBASE, the linked server has worked fine, but for some reason it would accept the local server and I get the error:
Could not find server 'MAGGIE' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
The query I am using is below
WHERE TelVoutID NOT IN (SELECT TelVoutID from [GBLON3\STARBASE].[WEBBILL].[dbo].[wbTelVoiceOut])