SQL Query Across Servers

Exec sp_addlinkedserver [ @server = ] ‘server’      [ , [ @srvproduct = ] ‘product_name’ ]      [ , [ @provider = ] ‘provider_name’ ]      [ , [ @datasrc = ] ‘data_source’ ]      [ , [ @location = ] ‘location’ ]      [ , [ @provstr = ] ‘provider_string’ ]      [ , [ @catalog = ] ‘catalog’ ] Select * From ServerName.DbName.SchemaName.TableName