sys.database_files vs sys.master_files

  • Recently I moved my production DBs to a new server (sql2012). While doing so, I renamed my logical file names to be consistent with new standards. after doing so, sys.database_files reflects the new names. however, sys.master_files only updated some of the names. this is a problem for me because I use sys.master_files to collect data via fileProperty(file_name, property) across multiple databases. I can't reproduce the problem on other databases. I've tried renaming the files again (both via gui and with ALTER DATABASE MODIFY FILE statements), and nothing changed. Any idea how to correct the name in sys.master_files?

  • Do you have VIEW ANY DEFINITION permission?

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

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