LINKED SERVER PROBLEM (help needed URGENT)

How to join tables from different servers? <top>

To be able to join tables between two SQL Servers, first you have to link
them. After the linked servers are setup, you just have to prefix your tables
names with server name, database name, table owner name in your SELECT queries.
The following example links SERVER_01 to SERVER_02. Execute the following
commands in SERVER_02:

EXEC sp_addlinkedserver SERVER_01
GO

/* The following command links 'sa' login on SERVER_02 with the 'sa' login
of SERVER_01 */
EXEC sp_addlinkedsrvlogin @rmtsrvname = 'SERVER_01', @useself = 'false',
@locallogin = 'sa', @rmtuser = 'sa', @rmtpassword = 'sa password of SERVER_01'
GO

SELECT a.title_id
FROM SERVER_01.pubs.dbo.titles a
INNER JOIN SERVER_02.pubs.dbo.titles b
ON a.title_id = b.title_id
GO

"Madhavi" <madhavi@yahoo.com> wrote:
>
>
>Hi I am working on a PRODUCTION SERVER , i know the another production Server
>Name , Login password Details, i am able to Setup NEW Server Registration
>from ENTERPRISE MANAGER and i am able to see the Database and all work.
When
>i am trying to map a Linked Server on Production , i am using same user
id
>and Password, while Registering it is not giving any Error message , but
>when i click on tables under the Server i am not able to see any Tables
i
>am getting a ERROR MESSAGE
>ERROR : 17 SQL Server does not exist or Access Denied.
>
>Note: i am able to see the server and it is running fine from the Enterprise
>Manager..
>How to Fix this one.
>
>
>Thanks
>Madhavi..
>