dbcc shrinkfile system views

  • After i shrink the transaction log file it displayed the used pages , estimated pages etc.

    If i want to know beforehand how much is available which system view would i need to see?

    TIA

    gk

    Knowledge grows by sharing ,not by keeping to oneself

  • If you want to see the reserved disk space and the unallocated space you can use the sp_spaceused stored procedure.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply