Using Linked Servers in SQL Server

When you work with software you have in mind that everything is interconnected, even more when you're talking about servers. And things could get really ugly if you need to make queries and see that a part of your information is located in another server.

Fortunately, Microsoft SQL Server helps us in this situation giving us a feature that allows us to reference a different server and use it to make queries against it.

So, let's open SQL Server Management Studio, get in to the server and go to "Linked Servers" folder located in "Server Objects".
 
Go to Linked Servers in SQL Server MS
 
Now, you have to create a new linked server by using the right-click button and the appropriate option.

Create a new linked server
 
In this ocasion, just type the linked server name on the textbox and select the type of this, keep in mind that you can connect to other sources different from SQL Server.

Complete the information of the linked server
 
After you do this, on the "Security" section you have to specify the mapping between users and for the rest of users you'll have to select the connection mode.

Configure the users for the linked server

Once you finish this, you will be able to query the data from your new linked server, this will appear under the "Linked Servers" folder. Since now you can build this kind of queries:

SELECT * FROM TEMP.CATALOGTEMP.DBO.TEMPTABLE

That's all.


Comments

Post a Comment

Popular posts from this blog

I Need to Send an Automatic Email with Lotus Notes

Image
If you don't know, Lotus Notes is an email client used in a lot of companies around the world. Therefore, I use it at work everyday, but someday I needed to send an automatic email to a few people all Fridays at 10:00.   To get this task accomplished I decided to create an agent and avoid remembering the fact of sending the email. As you can image, I did this example on a Spanish version of Lotus Notes 8.5 but I will explain it clearly enough. The first step is getting yourself into the inbox, then select the "Create" menu item and inside of it, click on "Agent...". You will get a dialog box opened, in this we have the possibility of setting the rules for this agent. However, in this case we will only set "Trigger" option to "On schedule" with the "Weekly" frequency. Don't forget to push the "Schedule..." button to program the agent in the right way. After this, select "OK" and close the dialog bo...
Read more

Turn Horizontal Visio Swimlanes into Vertical Ones

Image
In one ocassion, a friend at work called me because she had a problem with Microsoft Visio , she was trying to draw a process flowchat but using swimlanes, this was not a problem until she realized that it would be better to use vertical swimlanes instead of horizontal ones.    But, when she tried to drag a vertical one it just put together to the previous swimlanes created before.  To avoid creating a new visio document and lost your work just go to 'Cross-Functional Flowchart' ribbon and select 'Orientation' and 'Vertical'.     And it's done, now you can work with vertical swimlanes or if you like it you can turn them back to horizontal ones.
Read more

Install TWRP Recovery in Xiaomi Redmi 6A

Image
Case: You try to install TWRP Recovery in your Xiaomi Redmi 6A, but the official process doesn't work. Requisites: Xiaomi Redmi 6A phone, USB cable, computer with Windows and TWRP Cactus Tools installed . Steps: Make sure the phone is connected to the computer and in debug mode.  Open TWRP Cactus Tools: Click 'Flash TWRP' and select the right TWRP (be careful with the Android version): Click 'Start Flash' Results: The flash will finish and your phone will have the TWRP recovery.
Read more