title: Linked Server In SQL Server Express
body: <p>I am developing an app where i have a local database in SQL Server Express. During work in local database, we need to execute a query on another SQL Server / live server  and its return a value and with this value we execute a query in local server. </p>
  
  <p>It is OK when executing this query against 2 or 3 queries, but i have around 5000 records on which I need to execute same process. I have done with above style but its take too much time.</p>
  
  <p>I've found that we can run a query on multiple servers. </p>
  
  <p>Can i run a query on SQL Server Express and server at same time and and run my whole queries in this style?</p>
  
  <p>I can run query from express to server only.</p>