SQL Server - How to create LinkedServer using SMO

Vivek Johari

Rate me:

4.71/5 (5 votes)

26 Nov 2010CPOL

12K

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.

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

1. SQL Server - How to create LinkedServer using SMO

13 Nov 2010Kanasz Robert

1 alternative

SQL-Server

License

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

Written By

Vivek Johari

Database Administrator

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

SQL Server - How to create LinkedServer using SMO

Alternatives

License

Comments and Discussions