Error of finding a database size using a SQL query in SQL Server 2008 on Windows 7 -
    i use sql query find size of databases in sql server 2008 ms sql server management studio.   i run sql query:    select       d.name,      round (sum(mf.size) * 8 / 1024, 0) size_mbs        sys.master_files mf  inner join       sys.databases d on d.database_id = mf.database_id        d.database_id > 4 -- skip system databases      , d.name = 'my_database'  -- after removing this, still cannot find 'my_database' in results.  group       d.name  order       d.name   my_database  has been set on server result show nothing , cannot find it!   any appreciated.   thanks !          check user running has permission see database.  try logging sql management studio using credentials , connection string running query with.