SQL Script to find the database & their files details on a SQL Server

SQL Script to find database details Sometimes we need a SQL Script which can give the below information about the databases created on a SQL Server for house keeping purpose: -1) Database Name 2) Database ID 3) Database Files name with their physical location 4) Database Creation Time 5) Users access type for Database 6) […]

Continue Reading