Default Database

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?
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@.hotmail.com> wrote in message
news:%23QC2YWnQHHA.4276@.TK2MSFTNGP02.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?
>
|||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@.shadhawk.com> wrote in message
news:%23DjWvrnQHHA.3592@.TK2MSFTNGP06.phx.gbl...
> 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@.hotmail.com> wrote in message
> news:%23QC2YWnQHHA.4276@.TK2MSFTNGP02.phx.gbl...
>
|||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@.shadhawk.com> wrote in message
news:%23DjWvrnQHHA.3592@.TK2MSFTNGP06.phx.gbl...
> 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@.hotmail.com> wrote in message
> news:%23QC2YWnQHHA.4276@.TK2MSFTNGP02.phx.gbl...
>
|||Thanks... that worked.
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:523hi4F1mjp3rU1@.mid.individual.net...
> hi Wayne,
> Wayne wrote:
> 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
>