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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-03-30 : 09:20:31
|
robert writes "Hi,How do I connect to the named instance on localhost using isql or osql?i tried:osql -S <servername> -d <db name> -E ( this works for local db)for named instance, i tried:osql -S <servername\named_instance> -d <db name> -E (it doesn't work)Any help would be appreciated. Thx!R-" |
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-30 : 09:21:42
|
You can use (local) (parentheses required) or a single period . without parentheses, both refer to the default local instance:osql -S(local)...or...osql -S. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-03-30 : 09:29:28
|
Ugh, that's is what happens when I don't have my coffee, for NAMED INSTANCES the following works:osql -S(local)\instancename...or...osql -S.\instancename |
|
|
|
|
|