Procedure to moniter database

[rsrinivasan]

Hi all,

Is any system procedure is available in sql server 2000 to moniter the database growth?

Thanks,

[ck9663]

Hi all,

Is any system procedure is available in sql server 2000 to moniter the database growth?

Thanks,

please define monitor

-- ck

[rsrinivasan]

please define monitor

-- ck

I want to know each and every table growth from previous day over some period.

[ck9663]

I want to know each and every table growth from previous day over some period.

create a job that will run every end of the day when there's less server activity to gather all the information you need and store it in the table...am not sure if sys.sysindexes system table is available at SQL 2000.

-- ck