Hi Michel ---
An error occured when processing one or more transactions, is what happened. Go to the Error Log from the Server menu in SQL Enterprise Manager to get more info on what happened.
To get more info if this occurs in the future, set the "recovery flags" parameter via sp_configure to 1, from the default 0.
>Today, when I tried to access my database on the SQL Server, as I did the other days, I got the message saying that the database is recovering. When I look in SQL Server, I see the database is disabled and the mention Recovering is beside.
>
>Any idea of what may have caused that and how to recover?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05