Re: Default Database

#1

have a look in BooksOnLine for
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/469ea8e2-79b9-44c8-bb6f-f0e1c5dbf0f2.htm

--
Andrew J. Kelly SQL MVP

"Wayne" <wayneNoSpam (AT) hotmail (DOT) com> wrote

Quote:

I am using SQL Server Management to access a remote SQL Server. That server
has many databases but I have rights to only one so I set that as the
default database. In the connection properties it shows the correct
database
but when I open the connection to that server I get the list of all the
databases instead of just the one I set as default? How can I get it to
open
(show) just that one database?

#2

Andrew;

Thanls for your response. I tried that link as a search argument in BOL but
it was not found? Is there another way I should locate it?

Wayne

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

have a look in BooksOnLine for
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/469ea8e2-79b9-44c8-bb6f-f0e1c5dbf0f2.htm

--
Andrew J. Kelly SQL MVP

"Wayne" <wayneNoSpam (AT) hotmail (DOT) com> wrote in message
news:%23QC2YWnQHHA.4276 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
I am using SQL Server Management to access a remote SQL Server. That
server
has many databases but I have rights to only one so I set that as the
default database. In the connection properties it shows the correct
database
but when I open the connection to that server I get the list of all the
databases instead of just the one I set as default? How can I get it to
open
(show) just that one database?

#3

Andrew;

Thanks for the response. When I entered that as a Search in BOL it was not
found? Is there another way I can locate that?

Wayne

"Andrew J. Kelly" <sqlmvpnooospam (AT) shadhawk (DOT) com> wrote

Quote:

have a look in BooksOnLine for
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/toolref9/html/469ea8e2-79b9-44c8-bb6f-f0e1c5dbf0f2.htm

--
Andrew J. Kelly SQL MVP

"Wayne" <wayneNoSpam (AT) hotmail (DOT) com> wrote in message
news:%23QC2YWnQHHA.4276 (AT) TK2MSFTNGP02 (DOT) phx.gbl...
I am using SQL Server Management to access a remote SQL Server. That
server
has many databases but I have rights to only one so I set that as the
default database. In the connection properties it shows the correct
database
but when I open the connection to that server I get the list of all the
databases instead of just the one I set as default? How can I get it to
open
(show) just that one database?

#4

hi Wayne,
Wayne wrote:

Quote:

Andrew;

Thanls for your response. I tried that link as a search argument in
BOL but it was not found? Is there another way I should locate it?

paste the Url Andrew provided in the "Url:" box in the right pane of the
BOL, near the "search" combo.. or just have a look at
http://msdn2.microsoft.com/en-us/library/ms173849.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

#5

Thanks... that worked.

"Andrea Montanari" <andrea.sqlDMO (AT) virgilio (DOT) it> wrote

Quote:

hi Wayne,
Wayne wrote:
Andrew;

Thanls for your response. I tried that link as a search argument in
BOL but it was not found? Is there another way I should locate it?

paste the Url Andrew provided in the "Url:" box in the right pane of the
BOL, near the "search" combo.. or just have a look at
http://msdn2.microsoft.com/en-us/library/ms173849.aspx
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://italy.mvps.org
DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
--------- remove DMO to reply

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

Re: Default Database

microsoft.public.sqlserver.clients microsoft.public.sqlserver.clients

Re: Default Database - 01-27-2007 , 07:23 PM

Re: Default Database - 01-28-2007 , 04:56 AM

Re: Default Database - 01-28-2007 , 04:58 AM

Re: Default Database - 01-28-2007 , 06:00 AM

Re: Default Database - 01-28-2007 , 06:55 AM