DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advance
In Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:

>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? or
>perhaps point me to performance tables which contain this data?
>Thanks in advance

DB Statistics

Help please
I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
Is there an easy way to get DB/table statistics, table name, rows, last
accessed.
Thanks for any direction and assistance.
George
Hi,
sp_monitor -- Gives the SQL Server statistics
sp_helpdb <dbname> -- Gives you the details of database size, Options set,
FIle group information , File details...
Table -- Query the sysobjects table for name, created date
Number of rows -- sp_spaceused <table name>
Last accessesed date for table will not be stored by default , you may neeed
to write a trigger or use Log explorer from Lumigent.com
sp_configure -- Gives you all the parameter list and its values.
Thanks
Hari
MCDBA
"george collins" <george@.nospan.com> wrote in message
news:e44UTyvJEHA.620@.TK2MSFTNGP10.phx.gbl...
> Help please
> I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
> Is there an easy way to get DB/table statistics, table name, rows, last
> accessed.
> Thanks for any direction and assistance.
> George
>

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advanceIn Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:

>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? o
r
>perhaps point me to performance tables which contain this data?
>Thanks in advance

DB Statistics

Help please
I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
Is there an easy way to get DB/table statistics, table name, rows, last
accessed.
Thanks for any direction and assistance.
GeorgeHi,
sp_monitor -- Gives the SQL Server statistics
sp_helpdb <dbname> -- Gives you the details of database size, Options set,
FIle group information , File details...
Table -- Query the sysobjects table for name, created date
Number of rows -- sp_spaceused <table name>
Last accessesed date for table will not be stored by default , you may neeed
to write a trigger or use Log explorer from Lumigent.com
sp_configure -- Gives you all the parameter list and its values.
Thanks
Hari
MCDBA
"george collins" <george@.nospan.com> wrote in message
news:e44UTyvJEHA.620@.TK2MSFTNGP10.phx.gbl...
> Help please
> I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
> Is there an easy way to get DB/table statistics, table name, rows, last
> accessed.
> Thanks for any direction and assistance.
> George
>sql

DB Statistics

In the past I have seen a graphic display of space allocation of various db
objects (tables, indexes, etc...). I don't remember if it was sql server 7
or 2000.
Now I have installed sql server 2000 administrative client software. With
it I am accessing sql server 7 db. However, I can't find this graphic
representation.
Would anyone know how to make space allocation graphics appear it appear? or
perhaps point me to performance tables which contain this data?
Thanks in advanceIn Enterprise Manager, right click on the database, select
View and then select Taskpad View.
The graphed view of the space for the database will be on
the bottom of the General tab page in Taskpad view.
-Sue
On Tue, 9 Nov 2004 13:10:13 -0800, "RG"
<RG@.discussions.microsoft.com> wrote:
>In the past I have seen a graphic display of space allocation of various db
>objects (tables, indexes, etc...). I don't remember if it was sql server 7
>or 2000.
>Now I have installed sql server 2000 administrative client software. With
>it I am accessing sql server 7 db. However, I can't find this graphic
>representation.
>Would anyone know how to make space allocation graphics appear it appear? or
>perhaps point me to performance tables which contain this data?
>Thanks in advance

DB Statistics

Help please
I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
Is there an easy way to get DB/table statistics, table name, rows, last
accessed.
Thanks for any direction and assistance.
GeorgeHi,
sp_monitor -- Gives the SQL Server statistics
sp_helpdb <dbname> -- Gives you the details of database size, Options set,
FIle group information , File details...
Table -- Query the sysobjects table for name, created date
Number of rows -- sp_spaceused <table name>
Last accessesed date for table will not be stored by default , you may neeed
to write a trigger or use Log explorer from Lumigent.com
sp_configure -- Gives you all the parameter list and its values.
Thanks
Hari
MCDBA
"george collins" <george@.nospan.com> wrote in message
news:e44UTyvJEHA.620@.TK2MSFTNGP10.phx.gbl...
> Help please
> I am an old UNIFY guy and I am doing some work on SQL2000 for a customer.
> Is there an easy way to get DB/table statistics, table name, rows, last
> accessed.
> Thanks for any direction and assistance.
> George
>

DB Maintenance Plans failing - How to fix?

Created 'Database Maintenance Plans' to check integrity
of database, to update statistics for query analyzer
queries, to update data pages and index pages.
The Database Maintenance Plans jobs are failing with
error: 4062, cannot open user default database '<ID>'.
Using master instead. The weird thing about it is that
the error refers to an old job/master plan name.
It looks like the database for Database Maintenance Plans
is corrupted - using data from old plans for new plans.
What needs to be done to fix this problem?Using SQL Server 7 and Windows 2000 server.
>--Original Message--
>Created 'Database Maintenance Plans' to check integrity
>of database, to update statistics for query analyzer
>queries, to update data pages and index pages.
>The Database Maintenance Plans jobs are failing with
>error: 4062, cannot open user default database '<ID>'.
>Using master instead. The weird thing about it is that
>the error refers to an old job/master plan name.
>It looks like the database for Database Maintenance
Plans
>is corrupted - using data from old plans for new plans.
>What needs to be done to fix this problem?
>.
>|||The output text file was refering to a previous job. No
other references to previous jobs was seen.
>--Original Message--
>Created 'Database Maintenance Plans' to check integrity
>of database, to update statistics for query analyzer
>queries, to update data pages and index pages.
>The Database Maintenance Plans jobs are failing with
>error: 4062, cannot open user default database '<ID>'.
>Using master instead. The weird thing about it is that
>the error refers to an old job/master plan name.
>It looks like the database for Database Maintenance
Plans
>is corrupted - using data from old plans for new plans.
>What needs to be done to fix this problem?
>.
>|||Solved the issue. The MSSQLSERVER service login default
database had been changed to point to a database other
then 'master'. Apparently this is a prerequisite for
jobs to run. Once the MSSQLSERVER service login was
pointed at the 'master' database jobs ran.