Count rows in DB,with Table name,SpaceUsed, Update Statistic

• Kashif A

  Grasshopper

  Points: 13

  More actions

  August 5, 2006 at 8:05 pm

  #169231

  Hi ! Can any one help me as a newbie ASAP Pl.

  I need some simple code or SP to do the task,counting rows in whole DB with table name and space used, compute statistics & record it. When again run the code after few days it do comparision with the last run and shows what changes happen to compare to new run and force update statistics and record it for next run. I need the script(code), to test.

  Thanks & Appreciate any help--

   

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  August 7, 2006 at 5:01 pm

  #653755

  There is a "scripts" section in this website. You might find some code similar to what you want over there. Why reinvent the wheel?

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************