SQL Server Management Studio - How to Create Local Database Connection and Connect to It

preview_player
Показать описание
The easy way to create a local db in SQL Server Management Studio.
====================
Commands used:

sqllocaldb create "VerbTables"
sqllocaldb info "VerbTables"
sqllocaldb start "VerbTables"

To delete, use:
sqllocaldb stop "VerbTables"

To find your local db instances:
Win+R (or just search Windows for 'run') then paste in:
%LOCALAPPDATA%\Microsoft\Microsoft SQL Server Local DB\Instances\

==================
Remember - it's never too late!

Cheers,
Steve

Remember - it's never too late!

Cheers,
Steve
Рекомендации по теме
Комментарии
Автор

Commands used:

sqllocaldb create "VerbTables"
sqllocaldb info "VerbTables"
sqllocaldb start "VerbTables"

To delete, first use:
sqllocaldb stop "VerbTables"
Then you can delete the instance from SSMS/on your computer as needed

To find your local db instances:
Win+R (or just search Windows for 'run') then paste in:
SQL Server Local DB\Instances\

Server name (once created):
(localdb)\VerbTables

latedeveloper
Автор

thank you so much bro, i was struggling to get it right and you really helped me :)

SANGUEJOVEM
join shbcf.ru