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.