Generate list of database tables and size
Posted on 2007-11-20
I have a SQL Server 2000 DBMS with 70+ databases that I need to manage. I am having trouble figuring out a way to generate a list of tables within each db along with the size they are taking up on the server. I looked around the internet and found several references to 'sp_spaceused' and 'sp_MSforeachtable', but I'm not quite sure how I could implement either to generate one long list of all the tables in all my databases. Do I have any options?