linked server

Is there any site that shows me steps how to add linked server in Enterprise manager?

check out sp_addlinkedserver in books on line.

In SQL 2005, in the Object Explorer, right-click Server Objects, select New, and select Linked Server.

|||

Thanks for the reply. Can you give me example of sp_addlinkedserver for SQL 2000, I do not know what parameters are mandatory, it is complex to me. Is this the only one I need to run?

|||

There are a few parameters you need to pass like provider name, datasource.etc. Please check the documentation.

|||

Hi Dinakar,

Thanks for your reply. I am completely new on the SQL Server. I need to get this done very soon. I

executed:

EXEC sp_addlinkedserver 'aNewName', N'SQL Server'

in my local computer, when I clicked tables under created linked server aNewName, it gives me "no permission". I am actually trying to create a link in my computer to a SQL Server in the network. I used the command above but the command did not specify which server I want to connect. What am I missing?

|||Thanks I figured out this.