EM vs MS

Hi,
I'm switching from EM/QA to MS and was looking for the Prosses List in MS
(The info that is in Management->Current Activity->Process Info in EM). The
closest I found in MS was the Management->Activity Monitor, however, the
screen is blank and when I double click it, I get:
-- cut --
TITLE: Microsoft SQL Server Management Studio
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Unable to execute requested command.
Unable to launch Activity Monitor. You may not have sufficient permissions.
(ActivityMonitor)
Invalid object name 'sysdatabases'. (Microsoft SQL Server, Error: 208)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00 .0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476[/url]
BUTTONS:
OK
-- cut --
Everything works fine in EM
Thanks,
Jay
Hmm,
Never mind, I guess. I changed my default database to master and now the
activity monitor works.
Not that I understand it though.
Jay
"Jay" <nospam@.nospam.org> wrote in message
news:ef14ysiIIHA.484@.TK2MSFTNGP06.phx.gbl...
> Hi,
> I'm switching from EM/QA to MS and was looking for the Prosses List in MS
> (The info that is in Management->Current Activity->Process Info in EM).
> The closest I found in MS was the Management->Activity Monitor, however,
> the screen is blank and when I double click it, I get:
> -- cut --
> TITLE: Microsoft SQL Server Management Studio
> --
> Cannot show requested dialog.
> --
> ADDITIONAL INFORMATION:
> Unable to execute requested command.
> --
> Unable to launch Activity Monitor. You may not have sufficient
> permissions. (ActivityMonitor)
> --
> Invalid object name 'sysdatabases'. (Microsoft SQL Server, Error: 208)
> For help, click:
> [url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00 .0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476[/url]
> --
> BUTTONS:
> OK
> --
> -- cut --
> Everything works fine in EM
> Thanks,
> Jay
>
|||A bug huh? Should I report it, or has that already been done?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:93CC8C6D-0C4D-471F-9C51-05940C92AC68@.microsoft.com...
> Seems the dialog opens a connection without specifying what database to go
> to, and does something like
> SELECT ... FROM sysdatabases
> And if it isn't in master, then the error message is expected. I assume
> this was against a 2000 server? In any case, definitely a bug in SSMS.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23RL5FviIIHA.3848@.TK2MSFTNGP05.phx.gbl...
>