Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
niranjankumark
Posting Yak Master
164 Posts |
 Posted - 2008-01-31 : 05:31:34
|
| sp_mstablespace 'table_name'this givesrows dataspace indexspace12 234 20requirement i need to take all tables with table name.. in single executement...output should be :name Table rows dataspace indexspacetable_name 12 234 20 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-31 : 11:31:58
|
| EXECUTE sp_MSforeachtable @command1=" Print '?' EXECUTE sp_MStablespace '?'"Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
 |
|
|
|
|
|
Need qry