I know this should be straight forward, but cannot get it to work...
2 servers, both running SQL 2005
I need to link to Server B from Server A to run queries
I am assuming sp_addlinkedserver to be the way to go....so....
I executed the following query from Server A...(obviously the names have been changed to protect the innocent)
Response was "Command(s) completed successfully."
I then try to run a query as such....
WHERE description like '%stuff%'
Intellisense doesnt like it, but I ran it anyway and got the following error....
Msg 208, Level 16, State 1, Line 6
Invalid object name 'myFriendlyName.actualDBName.tableName'.