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

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 increased the size

Hello...Can someone help me please?

I had a mdf file with 48 Mb...and suddenly, the size of it increased
to 690 Mb (without any action or movement of data)...

Why could it be done?...is there any solution for thar?

Thank you.

Tony"Tony" <toni.gomez@.aidico.es> wrote in message
news:177dfda5.0405110012.199c71d0@.posting.google.c om...
> Hello...Can someone help me please?
> I had a mdf file with 48 Mb...and suddenly, the size of it increased
> to 690 Mb (without any action or movement of data)...
> Why could it be done?...is there any solution for thar?
> Thank you.
> Tony

Is it possible that someone else increased the file size manually? Or if the
file is set to autogrow, could someone have INSERTed then DELETed a large
amount of data? Or did someone create a very large number of indexes
(unlikely)? It can be normal that the .ldf file grows a lot in some
situations, but the .mdf should not unless there really are extra data or
objects in the database.

Simon