Table sizes in MS SQL

[Anonymous]

Hi,

Anybody who has an idea of how use QlikView to actually extract database/table systems/size information from an SQL server.

I am thinking of something like:

SELECT sp_msforeachtable 'exec sp_spaceused [?] ';

But QlikView considers that the latter part is garbage, which I could agree on.

I cannot get a good result in MS SQL Server Management Tool as I have 100+ tables.

(If any have developed a script that actually brings out both sizes, rows and even field names that would of course be even better...)

Kind regards

Niklas Hedborg

[Anonymous]

I actually found the answer to the latter part regarding field (or column) names:

SQLTABLES;

SQLCOLUMNS;

Fantastic.