config default "database"/"initial catalog"

#1

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.

#2

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

Quote:

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.

#3

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

Quote:

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.

#4

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

Quote:

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.

#5

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

Quote:

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.

#6

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

Quote:

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.

#7

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

Quote:

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.

#8

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

Quote:

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.

#9

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

Quote:

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.

#10

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

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

config default "database"/"initial catalog"

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

config default "database"/"initial catalog" - 06-27-2008 , 01:21 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM

Re: config default "database"/"initial catalog" - 06-27-2008 , 02:33 PM