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:
http://go.microsoft.com/fwlink?Prod...08&LinkId=20476
BUTTONS:
OK
--
-- cut --
Everything works fine in EM
Thanks,
JayHmm,
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:
> http://go.microsoft.com/fwlink?Prod...08&LinkId=20476
> --
> BUTTONS:
> OK
> --
> -- cut --
> Everything works fine in EM
> Thanks,
> Jay
>|||Seems the dialog opens a connection without specifying what database to go t
o, 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...[v
bcol=seagreen]
> Hmm,
> Never mind, I guess. I changed my default database to master and now the a
ctivity monitor works.
> Not that I understand it though.
> Jay
> "Jay" <nospam@.nospam.org> wrote in message news:ef14ysiIIHA.484@.TK2MSFTNGP
06.phx.gbl...
>[/vbcol]|||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...
>|||Sure, report it. Connect will ask you to search if such has been filed befor
e you file it. My guess
is that this feature is so seldom used so the bug hasn't been discovered yet
(or not considered
file-worthy).
... At least I'd call it a but, I should add...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <spam@.nospam.org> wrote in message news:%23ZW0VIuIIHA.3768@.TK2MSFTNGP06.phx.gbl...[vbc
ol=seagreen]
>A bug huh? Should I report it, or has that already been done?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:93CC8C6D-0C4D-471F-9C51-05940C92AC68@.microsoft.com...
>[/vbcol]