How can we see all database tables name and sizes

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 19, 2008 at 2:40 pm

  #791722

  This script article has a view that is both accurate and avoids using cursors: http://www.sqlservercentral.com/scripts/tables/62545/

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Sandeep Saretha

  SSChasing Mays

  Points: 647

  More actions

  March 21, 2008 at 1:18 pm

  #792687

  I am able to see summary menu item in view menu in my home computer but same is not available in my other SSMS, both have SP2 installed.

  Thanks

  Sandeep

• Adam Haines

  SSC-Insane

  Points: 23217

  More actions

  March 21, 2008 at 1:34 pm

  #792693

  SP2 does not have a summary, it has Object Explorer Details. The reports are not listed on the Object Exploerer details, for SP2. You have to right-click the database and go to reports.

  ---

  
  My blog: http://jahaines.blogspot.com

• Sandeep Saretha

  SSChasing Mays

  Points: 647

  More actions

  March 21, 2008 at 1:38 pm

  #792694

  Thanks Adam, I was looking Summary menu Item in SP2.

  Appreciated your time and help