Post reply

Get Database info

  • January 20, 2014 at 10:26 pm

    #288618

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

  • January 21, 2014 at 7:50 am

    #1681924

    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?

  • January 21, 2014 at 8:29 am

    #1681958

    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

  • April 27, 2016 at 1:47 pm

    #1875062

    Thanks for the script.

  • April 27, 2016 at 1:47 pm

    #1875063

    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