| Thread-Topic: Activity Monitor: SQL 2005
| thread-index: AcYEtqv3CT7/oApERimnOFGHHQ7OsQ==
| X-WBNR-Posting-Host: 68.67.208.184
| From: "=?Utf-8?B?VG9tVA==?=" <tomt@newsgroup.nospam>
| Subject: Activity Monitor: SQL 2005
| Date: Mon, 19 Dec 2005 08:10:04 -0800
| Lines: 36
| Message-ID: <35FAA28A-3693-4385-A3DF-CE3474AB6***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
|     charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.tools
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.tools:29191
| X-Tomcat-NG: microsoft.public.sqlserver.tools
|
| Is this supposed to work with SQL Server 2000 databases? I get the
following
| message when trying to launch it on one of these:
|
| 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:
|

|
| ------------------------------
| BUTTONS:
|
| OK
| ------------------------------
|
| It works fine when connected to 2005 servers.
|
| Thanks,
|
| TomT
|

"Steven Cheng[MSFT]" wrote:

> Hi Tom,
>
> Welcome to MSDN newsgroup.
> Regarding on the launching Activity Monitor problem you mentioned, I think
> it is the expected behavior since Activity Monitor is a SQL Server 2005
> specific tool that targeting server /use activity monitoring. So for
> sqlserver 2000 instances they're not supported to use this tool though many
> common client components in sql 2005 managment studio are still available
> and can be launched for sql 2000 instance.   In addition, for sqlserver
> 2000, there exists other performance and activity monitoring tools:
>
> # Monitoring Server Performance and Activity
> http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_00mr.asp?frame=
> true
>
> Thanks,
>
> Steven Cheng
> Microsoft Online Support
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>
>
> --------------------
> | Thread-Topic: Activity Monitor: SQL 2005
> | thread-index: AcYEtqv3CT7/oApERimnOFGHHQ7OsQ==
> | X-WBNR-Posting-Host: 68.67.208.184
> | From: "=?Utf-8?B?VG9tVA==?=" <tomt@newsgroup.nospam>
> | Subject: Activity Monitor: SQL 2005
> | Date: Mon, 19 Dec 2005 08:10:04 -0800
> | Lines: 36
> | Message-ID: <35FAA28A-3693-4385-A3DF-CE3474AB6***@microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> |     charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.tools
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA02.phx.gbl microsoft.public.sqlserver.tools:29191
> | X-Tomcat-NG: microsoft.public.sqlserver.tools
> |
> | Is this supposed to work with SQL Server 2000 databases? I get the
> following
> | message when trying to launch it on one of these:
> |
> | 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.2
> 039&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
> |
> | ------------------------------
> | BUTTONS:
> |
> | OK
> | ------------------------------
> |
> | It works fine when connected to 2005 servers.
> |
> | Thanks,
> |
> | TomT
> |
>
>

> Given the error message you get:
>
>    Invalid object name 'sysdatabases'. (Microsoft SQL Server, Error: 208)
>
> My guess is that your default database on this server is not the master
> database.
>
> I made an experinment by connecting to an SQL 2000 with a user that
> had tempdb as its default database, and indeed I got this exact message.
>
> The part of the message that talks about insuffcient permission is
> bogus. On SQL 2005, you cannot tell whether an error is due to lack
> of permission or whether the object is really missing. But SQL 2000
> will always tell you the exact reason.

"Erland Sommarskog" wrote:

> Harolds (harolds@community.nospam) writes:
> > In SQL BOL it states "To view the Activity Monitor the user needs SELECT
> > permission to the sysprocesses and syslocks tables in the master
> > database on a SQL Server 2000 server. Permission to view these tables is
> > granted by default to the PUBLIC database role."
> >
> > I use two different SQL Server 2000 servers, one I can use Activity
> > Monitor on the other I get the same error, my securty for both servers
> > is identical.
>
> Given the error message you get:
>
>    Invalid object name 'sysdatabases'. (Microsoft SQL Server, Error: 208)
>
> My guess is that your default database on this server is not the master
> database.
>
> I made an experinment by connecting to an SQL 2000 with a user that
> had tempdb as its default database, and indeed I got this exact message.
>
> The part of the message that talks about insuffcient permission is
> bogus. On SQL 2005, you cannot tell whether an error is due to lack
> of permission or whether the object is really missing. But SQL 2000
> will always tell you the exact reason.
>
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
>

"TomT" <tomt@newsgroup.nospam> wrote in message
news:35FAA28A-3693-4385-A3DF-CE3474AB6B85@microsoft.com...
> Is this supposed to work with SQL Server 2000 databases? I get the following
> message when trying to launch it on one of these:
>
> 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.2039&EvtSrc=MSSQLServer&EvtID=208&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------
>
> It works fine when connected to 2005 servers.
>
> Thanks,
>
> TomT