Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
osql -L not outputting instance names?
- Thread starter insanity1
- Start date
try SQLCMD.
Scroll down to Microsoft SQL Server 2005 Command Line Query Utility
The parameter would be the same:
-George
"the screen with the little boxes in the window." - Moron
Scroll down to Microsoft SQL Server 2005 Command Line Query Utility
The parameter would be the same:
Code:
sqlcmd -L-George
"the screen with the little boxes in the window." - Moron
insanity1,
I used the same command just this week and had the same results.
But for 1 machine, it did return the instance name - this was my pc which has a named instance of SQL Server 2000 on it.
My guess is that if the instance is the default name MSSQLSERVER, it does not return the instance name. Not sure that's the reason though.
I get the same result when I use sqlcmd -L.
John
I used the same command just this week and had the same results.
But for 1 machine, it did return the instance name - this was my pc which has a named instance of SQL Server 2000 on it.
My guess is that if the instance is the default name MSSQLSERVER, it does not return the instance name. Not sure that's the reason though.
I get the same result when I use sqlcmd -L.
John
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question
