This article is just a note for something I forget the most: my LocalDB instance names. Sometimes when I open (SSMS) I lose time thinking and trying to figure out what is the name of my LocalDb. SQL Server Management Studio The solution is simple: open the terminal and run SQLLocalDb.exe i, where stand for . i information Now you can see the list of configured DBs. To use it in SSMS remember to use Windows Authentication. If you need more info about a specific instance, just run SQLLocalDB.exe i "InstanceName" where of course must be replaced with the real name you are looking for. InstanceName This command displays some info about the specified SQL instance: this info includes the version, the owner and the current state. If you want to have a list of all available commands, run SQLLocalDB.exe -?. These commands allow you to create and delete SQL instances, stop and start existing instances and so on. It's important to remember that here the spaces are treated as delimiters, so if your DB includes spaces inside its name, you must surround the name with quotes.

Retrieving your SQL LocalDB Instance Name: A How-To Guide

About Author

Comments

TOPICS

THIS ARTICLE WAS FEATURED IN

Related Stories

Untitled Story

A Beginner's Guide to Public Speaking: My Experience With My First Speech

Install Git on Windows

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

10 Free Resources to Become a Health Data Scientist

10 Best Online Courses to Learn Oracle and PL/SQL for Beginners

A Beginner's Guide to Public Speaking: My Experience With My First Speech

Install Git on Windows

10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required!

10 Free Resources to Become a Health Data Scientist

10 Best Online Courses to Learn Oracle and PL/SQL for Beginners

Light-Mode

Classic

Newspaper

Dark-Mode

Neon Noir

Minty

HN StartUps