Welcome to SSQA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Can't find linked server in management studio?

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under Security --> Linked Server. One of the Developer asked me how we can find same in SQL Server 2005 Management studio, here it is:

You will find under Management studio open connection against that SQL instance and see under Server Objects --> Linked servers.

For further reading on creating linked server against Oracle or any other data source refer to in addition to the books online examples look at:
http://support.microsoft.com/kb/280106
http://www.sqlusa.com/bestpractices2005/linkedservertooracle/

Posted: Thursday, June 28, 2007 7:41 AM by SQL Master

Comments

SSQA - SqlServer-QA.net said:

In SQL Server 2000 when you create a linked server then you can see that on Enterprise Manager under

# June 28, 2007 7:13 PM
Anonymous comments are disabled