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. t开发者_开发技巧o connect to database we write Use similarly is there any way to connect to database engine.

---

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.

---

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.