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.
>
>The log shows the entries during the last reboot. Some databases have been recovered. The 2 databases that I have a problem with have also been recovered. However, for them, the status recovering is shown permanently.
>
I'm flying blind here, but this could be a transaction log problem. run the stored procedure sp_dboption {database name} to see what your options are set for those two databases. It might be that you need to expand the transaction log. I'm having a hard time visualizing what SQL Enterprise Manager options to use to do this because I don't have access to it from my workstation today.
>>To get more info if this occurs in the future, set the "recovery flags" parameter via sp_configure to 1, from the default 0.
>
>Where do I go to set this? Can I do that if my database have the recovering flag permanent?
From ISQL, you can USE {database name} (just like VFP) and then EXEC sp_configure or EXEC sp_dboption.
------------------------------------------------
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