SQL list of all db create date ,creator and locaton details

This query will list all the dbs create date and creator and location details

--declare @dbname sysname  --set @dbname = 'pControl_zfs' -- database name  select name DBName, isnull(suser_sname(sid),'~~UNKNOWN~~') DBCreator, convert(nvarchar(11), crdate) CreateDate,  dbid, cmptlevel SQLCompatibility, filename dbloaction from master.dbo.sysdatabases  --where (@dbname is null or name = @dbname)