 | |
SQL Server Management Studio 2008 Express failed to retrieve data
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#81
 
| |||
| |||
|
Re: SQL Server Management Studio 2008 Express failed to retrieve d -
09-24-2008
, 05:31 PM
|
"Erland Sommarskog" wrote: I don't really follow what you are doing. Really? I could not tell with your arrogant first answer. The problem is using Management Studio Express (in my case 2008) accessing a server (in my case it is 2005 server). It connects fine to the server but when you goto the Databases folder list, you get the error from trying to get the list of databases. Mgt Studio 2005 gets the list fine but you could only access your database, which is fine but in 2008 you get that error on the list of databases so you cant browse to your database. |
frustrating to answer questions in these forums, because the posts
are quite unclear, and there are several possible options of what
could be wrong.
Yours was very clear, particularly when you say that it happens with
SSMS 2008 only.
The bug is really bad. What is really crazy is that Enterprise Manager
in SQL 2000 had the same behaviour. Well, you did not get an error,
but it still tried access all databases (to see if you had access).
And this is a pain on a server with a lot of databases in autoclose.
It's really incredible that they walked into that trap again.
Quote:
|
Not sure why it is trying to access each one, I do not want it too or need it too. |
reason why. Well, almost. Anyway, the information listed there is
mainly taken from sys.databases, but some information is not available
if the database has been shutdown, because it's set to autoclose.
So SSMS access the databases to get that infomation. Which of course
is a very bad idea for several reasons.
Quote:
|
And like Alberto mentioned, in the connection properties the default database is set to the one I want connected which I am the owner of. |
it makes sense. But keep in mind that a lot of people logs into
SSMS as admins, and have no special connection properties set up.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
#82
| |||
| |||
|
|
"Erland Sommarskog" wrote: I don't really follow what you are doing. Really? I could not tell with your arrogant first answer. The problem is using Management Studio Express (in my case 2008) accessing a server (in my case it is 2005 server). It connects fine to the server but when you goto the Databases folder list, you get the error from trying to get the list of databases. Mgt Studio 2005 gets the list fine but you could only access your database, which is fine but in 2008 you get that error on the list of databases so you cant browse to your database. |
frustrating to answer questions in these forums, because the posts
are quite unclear, and there are several possible options of what
could be wrong.
Yours was very clear, particularly when you say that it happens with
SSMS 2008 only.
The bug is really bad. What is really crazy is that Enterprise Manager
in SQL 2000 had the same behaviour. Well, you did not get an error,
but it still tried access all databases (to see if you had access).
And this is a pain on a server with a lot of databases in autoclose.
It's really incredible that they walked into that trap again.
Quote:
|
Not sure why it is trying to access each one, I do not want it too or need it too. |
reason why. Well, almost. Anyway, the information listed there is
mainly taken from sys.databases, but some information is not available
if the database has been shutdown, because it's set to autoclose.
So SSMS access the databases to get that infomation. Which of course
is a very bad idea for several reasons.
Quote:
|
And like Alberto mentioned, in the connection properties the default database is set to the one I want connected which I am the owner of. |
it makes sense. But keep in mind that a lot of people logs into
SSMS as admins, and have no special connection properties set up.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.