Linked Server In SQL Server Express

sql-server database sql-server-express linked-server
JSJ picture JSJ · Nov 12, 2010 · Viewed 17.3k times · Source

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.

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.

I've found that we can run a query on multiple servers.

Can i run a query on SQL Server Express and server at same time and and run my whole queries in this style?

I can run query from express to server only.

Answer

Saif Khan picture Saif Khan · Nov 12, 2010

Yes you can. Setup the LinkServer on the SQL Express then just pass your query in the four part name format

server . database . schema . object

example 

select * from LinkServer.mydatabase.dbo.Table

Related questions

How can I do a BEFORE UPDATED trigger with sql server?

I'm using Sqlserver express and I can't do before updated trigger. There's a other way to do that?

Read More
Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053

I am running Windows 7 32 bit and I have IIS, Visual Studio 2008, 2010 installed. I am haunted by this error in SQL Server 2008 which is: Windows could not start the SQL Server (SQLEXPRESS) service on local computer. Error 1053: The service did not …

Read More
"Cannot open user default database. Login failed." after installing SQL Server Management Studio Express

I have a database in a local file that is used by a program. The program has limited functionality and I needed to run some quick queries. I installed SQL Server Management Studio Express 2005 (SSMSE), connected to the SQL Server …

Read More