Home Forums SQL Server 2005 Administering "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details." RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

  • April 22, 2009 at 5:50 am

    #982101

    Ratheesh.K.Nair (4/22/2009)

    what is the status of your database?

    check the status using sp_helpdb

    I am not sure whether this command works if the database is not accessible.

    But other way of checking the status of the database is

    select databasepropertyex('','STATUS') this should work.