For Fetching data from database situated at another server, we have to create Linked Server.
Command for creating Linked Server and linked server login:
Use master
EXEC sp_addlinkedserver
@server = 'AnyServerName',
@srvproduct = '',
@provider = 'MSDASQL',
@provstr = 'DRIVER={SQL Server};SERVER=.;UID=myself;PWD=password;'
EXEC sp_addlinkedsrvlogin 'AnyServerName', 'false', NULL, 'myself', 'password'
U can see the server name by using this command
SELECT * FROM sys.servers
Now you have created LinkedSerever named 'AnyServerName'
by using this LinkedServerName you can fetch data from another database situated at another location
SELECT TOP 20 * from AnyServerName.DatabaseName.dbo.TableName