How to get SQL Server instance names on command prompt ?

by Yawer Iqbal

To get list of SQL Server instances on (DOS) command prompt use any of the following commands.

    SQLCMD -L

    OSQL -L

Please note L must be capital. These commands will show SQL Server instances of any versions installed on a machine.

Reference: http://stackoverflow.com/questions/141154/how-can-i-determine-installed-sql-server-instances-and-their-versions

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s