How do I find the default database in SQL Server?

Question

Set the default database for the user. Open SQL Server Management Studio. Open the database server in the Object Explorer (left panel). In Object Explorer, open Security > Logins. Right-click the user you created and choose Properties. On the General page, select a Default database. . Click OK.

What is the default database in SQL Server?

master - keeps the information for an instance of SQL Server. msdb - used by SQL Server Agent. model - template database copied for each new database.

How do I find the SQL Server database?

To view a list of databases on an instance of SQL Server1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2To see a list of all databases on the instance, expand Databases.View list of databases on SQL Server - Microsoft Docs

Expert · Answer

master - keeps the information for an instance of SQL Server. msdb - used by SQL Server Agent. model - template database copied for each new database.

Expert · Answer

To view a list of databases on an instance of SQL Server1In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.2To see a list of all databases on the instance, expand Databases.View list of databases on SQL Server - Microsoft Docs

How do I find the default database in SQL Server?

What is the default database in SQL Server?

How do I find the SQL Server database?

Related Questions