SqlDbx Forum

kumarbiren

Member

how to query for other server database table

Hi..I am new to sqldbx...and sybase ASE

I have to do the query on Test Server's database for Running Main Server, database's table..

Scenario:-

Main Server                             say MS
Main Server Database               say  MSDBO
Main Server Database Table      say  MSTable

I login at Test Server say TS under kum database. Here I wish to write a query..something like this

Select * from MS.MSDBO.MSTABLE;

what is the correct syntax..if anybody, please guide.

Regards
Kumar

viswa

Member

Re: how to query for other server database table

1. log in to MS  using your user ID and password.
2. run command.
2.a use MSDBO
2.b.GO
3. select * from MSTABLE