> information (even if object explorer details is not visible). On a shared
> hosting environment where you need to expand the database list and there
> are
> 500 databases, and other people may be doing it at the same time, and the
> server is not the beefiest thing in the world in the first place, this can
> be a real time waster.
The problem I experienced with this is different.
For example, I connect to a database which is hosted on a hosting company
using SSMS of SQL Server 2008. Then when I try to expand Databases node, it
complains about invalid user for the first database which I don't have right
to reach under this node.
Error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request.
(Microsoft.SqlServer.Management.Sdk.Sfc)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(
Microsoft.SqlServer.ConnectionInfo)
------------------------------
Server user 'myUserName' is not a valid user in database
'first_db_on_the_list'. (Microsoft SQL Server, Error: 916)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc...
------------------------------
BUTTONS:
OK
------------------------------
I can query against my tables using Query Editor but I can't see my database
(nor the others) on the Object Explorer.
Didn't this happen to you?
--
Ekrem Önsoy
"Aaron Bertrand [SQL Server MVP]"
wrote in message
news:C4D4ABE5.10085%%ten.xoc@dnartreb.noraa...>I don't know of any of the functionality that is missing. Some has
>changed,
> for example Open Table has split into Select Top and Edit Top. And some
> things have moved; I have seen many people complain that they can't find
> Activity Monitor, because they looked only in the old place. But there is
> definitely some new stuff. The only concern I have come across is that
> loading a server in Object Explorer the first time can be VERY slow
> because
> it loops through every single database to get object explorer details
> information (even if object explorer details is not visible). On a shared
> hosting environment where you need to expand the database list and there
> are
> 500 databases, and other people may be doing it at the same time, and the
> server is not the beefiest thing in the world in the first place, this can
> be a real time waster. I complained about this here but it hasn't
> received
> much traction:
>
>
http://connect.microsoft.com/sqlserver/feedback/ViewFeedback.aspx?FeedbackID
> =357349
>
>
>
> On 8/22/08 5:17 PM, in article
> 95DC6846-82FC-4AD1-A799-3A36C2AB6021@
microsoft.com, "TomT"
>
wrote:
>>> Are there any problems or issues in replacing just SSMS 2005 with the new
>> version - I'd like to get familiar with it, but we have not yet upgraded
>> our
>> databases to 2008 (they are, except for 2, 2005).
>>
>> I'm hoping to do this only on my client/dev system, which I use to
>> connect
>> to our SQL 2005 servers.
>>
>> Thanks
>
