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?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=208&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?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
> --
> BUTTONS:
> OK
> --
> -- cut --
> Everything works fine in EM
> Thanks,
> Jay
>|||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...
> 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:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
>> --
>> 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...
>> 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:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>> -- cut --
>> Everything works fine in EM
>> Thanks,
>> Jay
>>
>|||Sure, report it. Connect will ask you to search if such has been filed before 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...
>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...
>> 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:
>> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
>> --
>> BUTTONS:
>> OK
>> --
>> -- cut --
>> Everything works fine in EM
>> Thanks,
>> Jay
>>
>>
>