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.
Asked
Active
Viewed 7,716 times
0
-
1Connect with what? How do you mean "through SQL query"? – Oded May 04 '11 at 12:38
-
I want to connect to Database engine (SQL server) using Server name, User Name and Password through query in SQL Management studio – meetjaydeep May 04 '11 at 12:46
2 Answers
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.
Oded
- 489,969
- 99
- 883
- 1,009
0
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.
marc_s
- 732,580
- 175
- 1,330
- 1,459