Compare two tables from two different SQL servers

• osxman

  Old Hand

  Points: 366

  More actions

  March 19, 2019 at 11:35 am

  #383167

  Hi,

  I have two SQL servers both running 2014. My objective is to check if a field (Username) in Server A Table tbl_Users exists in Server B Table tbl_Users. If there is a match then append current date to that username in Server B tbl_users.

  I want to create a stored procedure on Server A, which can at some point be scheduled to execute.

  Is it possible to connect to Server B directly from the stored proc on Server A or do I have to look at creating a linked server. We currently don't use linked servers.

  Thanks

• Sue_H

  SSC Guru

  Points: 90860

  More actions

  March 19, 2019 at 12:29 pm

  #2024930

  osxman - Tuesday, March 19, 2019 11:35 AM

  Hi,

  I have two SQL servers both running 2014. My objective is to check if a field (Username) in Server A Table tbl_Users exists in Server B Table tbl_Users. If there is a match then append current date to that username in Server B tbl_users.

  I want to create a stored procedure on Server A, which can at some point be scheduled to execute.

  Is it possible to connect to Server B directly from the stored proc on Server A or do I have to look at creating a linked server. We currently don't use linked servers.

  Thanks

  Take a look at opendatasource which doesn't require a linked server:
  OPENDATASOURCE (Transact-SQL)

  Sue

• osxman

  Old Hand

  Points: 366

  More actions

  March 20, 2019 at 1:18 pm

  #2025056

  Thanks!