name in sys.master_files is different than database name

  • Would like to understand what's going on here. In sys.master_files, the 'name' column is different than the 'name' of the database in sysdatabases. The database ids match up.

    Any idea why sys.master_files shows it differently?

    TIA

    ----------------------------------------------------------------------------
    Sacramento SQL Server users group - http://sac.sqlpass.org
    Follow me on Twitter - @SQLDCH
    ----------------------------------------------------------------------------

    Yeah, well...The Dude abides.
  • The 'name' column in sys.master_files isn't the database name. It's the logical name of the file. To get the database name, either join to sys.databases or use the db_name function

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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