• check the states of all sys data bases too

    select state_desc, * from sys.databases.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)