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

Written by davidebellone | Published 2021/02/23
Tech Story Tags: sql | cmd | localdb | sql-server | sql-local-db-instance-name | ssms | forgot-localdb-instance-name | sql-beginner-tips

TLDR This article is just a note for something I forget the most: my LocalDB instance names. It's important to remember that here the spaces are treated as. as delimiters, so if your DB includes spaces inside its name, you must surround the name with quotes. This information includes the. version, the. owner, the current state and the. current. state of the DB. Use the. command in SSMS (SSMS) remember to use Windows. Authentication to use.via the TL;DR App

no story

Written by davidebellone | I write about .NET development and general coding stuff. - developer - blogger - speaker -
Published by HackerNoon on 2021/02/23