Re: SSMS problem display database list on remote server

Connect to a different (e.g. local) server, open Object Explorer Details and
turn off all the unnecessary columns, particularly collation, last backup
date, last log backup date, data space used, owner (in case it is NULL), and
the like. Only enable the bare minimum here. These have tripped me up in
the past because several of them have to go each individual database in a
loop to get the results. Of course in a hosted scenario you very rarely
will have the rights to do so, and that is where the error message comes
from.

Please vote so that this will get fixed in a service pack.

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=35523
8

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=35432
2

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=35429
1

Also see here for some more background info (I complained about this pretty
loudly back in July):

http://is.gd/3EwP

Actually I just noticed that you are using SSMS Express, not SSMS. Does
SSMS Express have an Object Explorer Details pane? Sorry, I don't have any
system where I can load it myself to check if the fix will be the same...





On 10/7/08 9:17 AM, in article O7ESO8HKJHA.5704@xxxxxxxxxxxxxxxxxxxx, "Ralf
Kaiser" <rk@xxxxxxxxxxxxx> wrote:

Hello,

i am using (well: want to use) SSMS Express 2008 to access our database on
the server of our hoster. Previously i did that with the 2005-version of
SSMS.

On that server there are several databases installed and we have only access
to two of them. When i connect to the server and open the node "Databases"
in SSMS i get an error message that i do not have the right to access some
of the databases (which is correct) and SSMS does not list ANY database in
that node, not even the ones that we are allowed to access.

Is it possible to create a connection to a single database, not listing the
others, with SSMS (i know the database names, so it would be no problem)? I
mean like in Visual Studio where i can add a connection to A SINGLE database
in the sever explorer.

Thnaks in advance,
Ralf


.

Relevant Pages

  • Re: Replace SSMS 2005 with SSMS 2008
    ... loading a server in Object Explorer the first time can be VERY slow because ... information (even if object explorer details is not visible). ... hosting environment where you need to expand the database list and there are ...
    (microsoft.public.sqlserver.tools)
  • Re: Detach database from SQL Server
    ... If you flush the pool to free the connection, you can't detach the database if the connection references it. ... SQL Server Management Studio (SSMS) is the interactive management suite of tools that can be used to perform any and all kinds of maintenance on the database. ...
    (microsoft.public.dotnet.framework.adonet)
  • SSMS problem display database list on remote server
    ... Previously i did that with the 2005-version of SSMS. ... On that server there are several databases installed and we have only access to two of them. ... When i connect to the server and open the node "Databases" in SSMS i get an error message that i do not have the right to access some of the databases and SSMS does not list ANY database in that node, not even the ones that we are allowed to access. ... I mean like in Visual Studio where i can add a connection to A SINGLE database in the sever explorer. ...
    (microsoft.public.sqlserver.tools)
  • Database filtering
    ... Right now, when users connect to SSMS or Enterprise Manager, they can see every database in the server. ... At first, I thought I could use filters as in database object with SMSS, but it seems like that doesn't apply to the databases node. ...
    (microsoft.public.sqlserver.tools)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)