SQL Server Performance Forum – Threads Archive

Table Size

How can i know the size of each table in a database?
plz send me some information

---

hi check this command sp_spaceused ‘table_name’ krishna chaitanya.s
project engineer-SQLDBA

---

Undocumented sp can be useful here sp_MSForEachtable ‘sp_spaceused ”?”’ Madhivanan Failing to plan is Planning to fail

---

use this command to get all the table size in a database: sp_msforeachtable ‘sp_spaceused"?"’ use result in text mode so that you will get the result and save it in text file. -Johnson

---

nice command madhivanan………..
krishna chaitanya.s
project engineer-SQLDBA

---

]]>