CODEWITHSUNDEEP
sql-serverssmsdatabase-engine
meetjaydeep
meetjaydeep

Reputation: 1850

Connect to Database Engine through query

When you open the SQL Server Management studio you connect to the Database engine through UI.I want same functionality through SQL query e.g. to connect to database we write Use similarly is there any way to connect to database engine.

Upvotes: 0

Views: 7904

Answers (2)

marc_s
marc_s

Reputation: 755033

In SQL Server Management Studio, you cannot connect to a server using server name, database name, user id and password from a query.

What you need to do is go to the Object Explorer, click on Connect and then Database Engine:

enter image description here

Once you're connected to a server, you can switch between databases using

USE (database name)

but you cannot connect to another server in a T-SQL query, as far as I know.

Upvotes: 0

Oded
Oded

Reputation: 499152

What you are looking for is not supported - you need to provide the credentials in the Connect to Server dialogue.

There is no way to have a query window open a connection to a database directly.

Upvotes: 3

Related Questions