Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jdblack
Starting Member
11 Posts |
 Posted - 2010-11-03 : 12:39:37
|
| Is there any command or method of connecting to a SQL instance without doing it through the GUI?I've got about 100 servers with multiple SQL instances. I'd like to make a script that takes a server name & figures out the correct instance to connect to. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jdblack
Starting Member
11 Posts |
Posted - 2010-11-03 : 12:47:19
|
| Doesn't help for this task, but thanks for the suggestion. The SQL server names aren't constant; at least a few servers are brought up and taken down each week by IT, and before connecting to the new servers we don't know which port/instance from a list of possibilities is the one we want. The queries will also potentially be run on 20+ revolving laptops/desktops in different countries owned by various people who don't know SQL. For those reasons this query (and others they use) are stored on a file share. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Connect to server from script?