Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- results = Invoke-SqlCmd -Query "SELECT DB_NAME(smf.database_id) AS db__name, CONVERT(DECIMAL(18,0), ((smf.size * 8192.0) / POWER(1,20))) AS Size_In_Bytes, smf.* FROM sys.master_files AS smf;";
- foreach ($Item in $results){
- $name = $item.Name
- $length = $item.size_in_bytes
- write-host "sql-$name-Database $length"
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement