Help me

Sinjith_shr

[b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently

abhishek12

: [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
: I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
:
:
: I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!

Shanoo

: : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
: : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
: :
: :
: : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
:
:

If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.

Sinjith_shr

: : : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
: : : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
: : :
: : :
: : : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
: :
: :
:
: If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.
:

Sinjith_shr

: : : : [b][red]This message was edited by Sinjith_shr at 2004-6-1 21:13:16[/red][/b][hr]
: : : : I have two SQL server machines running in same network.From my query analyzer i want to access both server objects from the same connection. I dont want to connect to server2 in the server1 Query Analyzer i will give the 'SA' user and password for both servers. Also I logged in as a sa user in the server1. Is it possible to do like that. If any body knows how to do this plz help me. I need it very urgently
: : : :
: : : :
: : : : I suppose you want to access the data from two server through the same query analyser??? If this is the case, you can use the format ... format to access the data. If this does not solve your problem then probably I have not understood your question. You can just explain me with an example. May be I'll be able to help you!!!
: : :
: : :
: :
: : If I am not wrong then you will have to use sp_addlinkedserver to make it work. After adding the remote server as linked server, you can use fully qualified name (described in the previous response) for accessing the tables of the remote server.
: :
:
:
Thks frds
it was the solutions i was looking for. Thanks for the support u have