Store Your Code Now
Tools: String Manipulations Find Dupes My IP Json Formatter Lorem Ipsum More...
Discussion Options

Change SQL Server Default Database for a User

7/19/2016 5:55:38 PM by: CodeLocker

In SQL Server, if you have a default database set for a user and that database gets deleted, you may not be able to login (so completely stupid Microsoft). To change the default password, do the following.

View Copy: Content Copied
From the RUN command or a command prompt
1) sqlcmd -E -S "MyComputerName\MyInstanceName" -d master

Copy: Content Copied

Get Coding

Store your first code or add more code to your collection.
You must login to report abuse. ×