new connection with query analyzer.

[chaoma]

Hi,

Let say if I need to change a database from Master to Northwind, I would type "Use Northwind" in query analyzer.

Is there a similar command to change to another SQL server?

Thank you for your assistance.

Chaoma

 

[gmmastros]

Not that I am aware of.

You can click, File -> Connect to connect to another server. You can have multiple query analyzer windows open, or even open query analyzer multiple times.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[jbenson001]

Or you can create a linked sever and access a table like this:

select * from servername.owner.tablename

 

[chaoma]

Thanks. Yes, I could access the table using a linked server, but it was just too long to pass data over the network. Anyone else?

 

[jbenson001]

Anyway you transfer the data, it will be going over the network, there is no way around that.