Click here to Skip to main content
15,881,248 members
Articles / Database Development / SQL Server
Alternative
Tip/Trick

SQL Server - How to create LinkedServer using SMO

Rate me:
Please Sign up or sign in to vote.
4.71/5 (5 votes)
26 Nov 2010CPOL 12K   5   2
Nice tip Kanasz :) You can also create the linkedserver through SQL SERVER MANAGEMENT STUDIO by following the following pathClick on the Server ObjectsRight click on the Linked servers under the Server Objects and select the New linked Server option.

Nice tip Kanasz :)


You can also create the linkedserver through SQL SERVER MANAGEMENT STUDIO by following the following path



  • Click on the Server Objects
  • Right click on the Linked servers under the Server Objects and select the New linked Server option.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Database Administrator
India India
I am currently working as a Senior DBA and have around 11 years of experience in database.

Degree:-
Master Degree in Computer(MCA)

Work experience:-
Designing of the database.
Database Optimization.
Writing Complex Stored Procedures,Functions,Triggers etc.
Designing and developing SSIS & DTS packages.
Designing SQL Reports using SSRS.
Database Server Maintenance.

Certification:-
Microsoft certified Sql DBA in Sql server 2008 (MCTS).
Microsoft certified BI professional in Sql server 2008 (MCTS).
Oracle certified profession DBA in ORACLE 10g (OCP)
certified profession DBA in ORACLE 9i (OCP)

My other publication
Technical Blog:- Technologies with Vivek Johari

Moderator and Blogger at BeyondRelational.com

Guest Author and Blogger at sqlservercentral.com

Comments and Discussions

 
Suggestionmmmm... Pin
Member 871442115-Apr-15 8:18
Member 871442115-Apr-15 8:18 
Generalyou are right, but this tip demonstrates how to create linke... Pin
Kanasz Robert27-Nov-10 23:22
professionalKanasz Robert27-Nov-10 23:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.