Connect to another server in Query Analyzer

Hello,
Is it possible to connect to another server and database using code in the
query analyze?. I'm trying to do the equivalent of ctrl+O with the name of
the server and database.
Any help with this would be appreciated.
Thanks in advance,
sck10No, once you execute code in QA, you execute that code in the SQL Server you
are connected to. In
SQL Server 2005, the successor to OSQL, called SQLCMD, will have that featur
e.
Changing database is simple, though, using USE.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"sck10" <sck10@.online.nospam> wrote in message news:u%237htHskFHA.3164@.TK2MSFTNGP15.phx.gbl.
.
> Hello,
> Is it possible to connect to another server and database using code in the
> query analyze?. I'm trying to do the equivalent of ctrl+O with the name o
f
> the server and database.
> Any help with this would be appreciated.
> --
> Thanks in advance,
> sck10
>