sql default sql server name code example

Example: how to set default database name in sql server

Exec sp_defaultdb @loginame='login', @defdb='master'