SQL table size

[Kris]

Hi all,

I'm trying to create a test that monitors the size of a specific table in MS SQL server...
Thus far I've been fiddling with the ODBC test, but no luck yet...

Could anyone point me in the right direction?

Thanks!
Kris

[KS-Soft]

This may depend on version of your MS SQL server.
Have you trid query like

SELECT ROUND(data_length/1024/1024,2) total_size_mb FROM information_schema.tables WHERE table_name = 'table_name' AND table_schema = 'database_name'

Also there is sp_spaceused stored procedure
http://msdn.microsoft.com/en-us/library ... 90%29.aspx

Regards
Alex

[Kris]

We ended up querying a stored procedure that returns the table size.

Thanks for pointing that out!