Connect to Database Engine through query

Question

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.

Answer 1

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:

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.

Answer 2

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.