config default "database"/"initial catalog"   

SSMS 2005 :

Is there a way to configure the default "database"/"initial catalog" for 
connections to a certain server/instance to something other than "master" ?

Thanks.

date: Fri, 27 Jun 2008 11:21:49 -0700   author:   John A Grandy johnagrandy-at-gmail-dot-com

Re: config default "database"/"initial catalog"   

You can use the DEFAULT_DATABASE option of CREATE\ALTER LOGIN command to set 
another default database for a Login.

ALTER LOGIN [EKREM-PC\Ekrem] WITH DEFAULT_DATABASE=[AdventureWorks]

-- 
Ekrem Önsoy



"John A Grandy" <johnagrandy-at-gmail-dot-com> wrote in message 
news:eWHCuKI2IHA.4572@TK2MSFTNGP03.phx.gbl...
> SSMS 2005 :
>
> Is there a way to configure the default "database"/"initial catalog" for 
> connections to a certain server/instance to something other than "master" 
> ?
>
> Thanks.
>

date: Fri, 27 Jun 2008 22:33:17 +0300   author:   Ekrem Önsoy