I need to query a table from another SQL Server on a different server but same domain, but I am not sure how I will be able to do it.
I tried the solution in this answer but it doesn't work for me as I got SQL Server 2000.
When I try solution given this sql command,
SELECT * FROM [AnotherServer].[AnotherServerDatabase].Server.Table1
Then I get error,
Msg 7202, Level 11, State 2, Line 1 Could not find server 'AnotherServer' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
If I try command below on live database, would it effect any customer ?
EXEC sp_addlinkedserver @server='AnotherServer'