Get Database info

  • Comments posted to this topic are about the item Get Database info

  • I tried running this on SQL 2012 and it didn't return anything... Looked a bit deeper and noted that the master.sys.master_files has no records. Any ideas?

  • David,

    Excellent script. Thanks for posting.

    One small point though; the size for tempdb that is found in master.sys.master_files is the NOT the actual size. It is the size that tempdb will be when SQL Server is restarted.

    Thanks again.

    Lee

  • Thanks for the script.

  • Lee Linares (1/21/2014)


    David,

    Excellent script. Thanks for posting.

    One small point though; the size for tempdb that is found in master.sys.master_files is the NOT the actual size. It is the size that tempdb will be when SQL Server is restarted.

    Thanks again.

    Lee

    Thanks for pointing that out.

Viewing 5 posts - 1 through 4 (of 4 total)

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