Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Connecting to another SQL SErver

Author  Topic 

jhnegrao
Yak Posting Veteran

81 Posts

Posted - 2006-01-19 : 07:46:09
Hello, All!

I am trying to connect to another instance using Transact SQL, but I didn't
get it yet.
Could we help me with it?

I tryed to use, CONNECT TO, but I always receive the same error message.
CONNECT TO server.db USER usr.password
"Incorrect syntax near the keyword 'to'."

Thanks

Juliano Horta

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-19 : 08:27:38
From Where u r going to connect to the SQL Server / DB
-- From a machine in the same network or outside ?
-- From ASP / VB kind of application or Query Analyzer / Enterprise Manager kind of tools ?
Go to Top of Page
   

- Advertisement -