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.
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