• WOW!!!

    Two good replacement scripts.

    However there is great sadness for the readers and users.

    Each script returns a differant value in KB for [Reserved].:w00t:

    Travis:

    TABLE_USERTABLE_NAMEROWSRESERVED_Kb

    dbo TN_AuditLog257106455120

    William:

    TableNameNumOfRowsTotalKB

    TN_AuditLog128553 732376

    Would the real Table size script please stand up?

    HINT: The 2008 SSMS UI tells me that TN_AuditLog RowCount = 128553, the Data space is 710 MB

    😎