Post reply

sp_helpfile- all databases

  • October 6, 2011 at 7:53 am

    #244955

    Hi I am using below script to get logical name of the dtabase.

    USE <databasename>

    GO

    SELECT file_id, name FROM sys.database_files

    is there any script to get logical names for all databases?

    Thanks!

  • October 6, 2011 at 7:55 am

    #1391204

    Start with this:

    select * from sys.master_files

    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