sqlcmd /Lc

[SQLScholar]

Hi,

When i run sqlcmd /Lc i get a list of servers that is slightly odd.

All is ok except that if i have a server called "server1" and on it is an instance not installed under the default called "instance1" i get.

server1
server1\instance1

Now server1 doesnt have anything installed on the default instance and you couldnt connect directly to server1.

Any idea why this is or how i can get a clean list.

Dan

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Dr. Seuss

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[mrdenny]

What port is the instance on server1 running on?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2005 BI / SQL 2008 DBA / SQL 2008 DBD / SQL 2008 BI / MWSS 3.0: Configuration / MOSS 2007: Configuration)
MCITP (SQL 2005 DBA / SQL 2008 DBA / SQL 2005 DBD / SQL 2008 DBD / SQL 2005 BI / SQL 2008 BI)
MCM (SQL 2008)
MVP

My Blog