Skip Navigation Links Home Blogs

cubido > Blogs > Posts > Get all files of all databases from SQL Server 2005 with a single query
January 29
Get all files of all databases from SQL Server 2005 with a single query

SELECT

 
    
sys.databases .name as database_name
,
    
sys.databases .state_desc As database_state
,
    
sys.databases .create_date as database_creationdate
,
    suser_sname ( sys.databases .owner_sid) As database_owner
,
    sys.master_files .name As logical_filename, 
    physical_name As physical_filename, 
    type_desc As file_type, 
    sys.master_files.size * 8 file_size_kbyte
FROM 
    sys.master_files 
    inner join sys.databases on sys.master_files.database_id = sys.databases.database_id

Comments

Re: Get all files of all databases from SQL Server 2005 with a single query

GRB 970508  was a gamma-ray burst (GRB) detected on May 8, 1997, at 21:42 UTC. <a href="http://www.certpaper.com/70-646.htm">70-646</a> A gamma-ray burst is a highly luminous  flash of gamma rays, the most energetic form of electromagnetic radiation, which is often followed by a longer-lived "afterglow" emitting at longer wavelengths (X-ray, ultraviolet, optical, infrared, and radio). GRB 970508 was detected by <a href="http://www.certpaper.com/70-647.htm">70-647</a> he Gamma Ray Burst Monitor on the Italian–Dutch X-ray astronomy satellite BeppoSAX. Astronomer Mark Metzger determined that GRB 970508 occurred at least 6 billion light years from Earth; this was the first measurement of the distance to a gamma-ray burst. Until this burst, astronomers had not reached a consensus regarding how far away GRBs occur from Earth. Some supported the idea that GRBs occur within the Milky Way, but are visibly faint because they are not highly energetic. Others concluded that GRBs occur in other galaxies at cosmological distances and are extremely energetic. Although the possibility of multiple types of GRBs meant that the two theories were not mutually exclusive, the distance measurement unequivocally placed the source of the GRB outside the Milky Way, <a href="http://www.certpaper.com/JN0-532.htm">JN0-532</a> effectively ending the debate. GRB 970508 was also the first burst with an observed radio frequency afterglow
CUBIDO\p.kirschnerNo presence information on 3/17/2010 10:01 AM
 

 Add Comment

 
Titel  
Your Name:  
Your Comment:  
Your EMail:  
*