How can I connect to another database?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 1

I do not understand well your question.

In TSQL there is no such command as connect.

First you have to connect to a server/database then you can issue TSQL commands.

Of cours you can connect to the server by using QA, EM, and all other client tools or programming languages.

What is exactly your question?

Bye

Gabor

Bye
Gabor

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

hm, maybe

USE <some other databasename>

GO

?????

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Gabor Nyul SSCrazy Eights Points: 9459 More actions · Answer 3

Or if this is you want, just use the:

"

use AnotherDBName

go

"

syntax. See BOL

Bye

Gabor

Bye
Gabor

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

well, yes....too late

Frank

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]