how to use Microsoft SQL. Using the Microsoft flavor I need help with something to show a
Fantastic news! We've Found the answer you've been seeking!
Question:
how to use Microsoft SQL. Using the Microsoft flavor I need help with something to show a list of all databases I have. This list needs to display three things for every file 1) File Name 2) File Location 3) file size (as listed in the database_files catalog view without conversion.
But the catch to that is I need to somehow limit the display to only show files greater than or equal to size 1024.
What I have come up with so far is this:
select
DB_NAME(database_id) AS DatabaseName,
size
FROM sys.master_files
Which shows me the name & the size, but it shows every file not just those of size 1024 or greater & it only shows me the name & size not the location.
Related Book For
Posted Date: