sys.sp_defaultdb

Description

Changes the default database for a SQL Server login. Server login or a Windows user or group. If a login for the Windows user or group doesn’t exist in SQL Server, it’s automatically added.

Syntax

sp_defaultdb
[ @loginame = ]
N
'loginame'
, [ @defdb = ]
N
'defdb'
[ ; ]