sql-serverssmsdatabase-engine

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.


Solution

  • 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.