sp_dboption 'Emerald','single user', TRUE
then close this iSQL connection
start the EM you'll notice a special icon next to the Emerald Database, indicating the single user mode.
to get it back to normal after changing what ever you want to change double click the emerald DB then un check the single user mode int the options menu.
At 04:23 PM 08/20/98 +1000, you wrote:
>Try deleting or renaming the Emerald.dat out of \mssql\data
>From: Humberto Guzman <<firstname.lastname@example.org>
>To: email@example.com <<firstname.lastname@example.org>
>Date: Friday, August 21, 1998 2:07 AM
>Subject: Emerald Database
>>I just installed Emerald on our server, but we keep getting an error
>>message when trying to create the database, we had created it, but deleted
>>it in the Emeral Admin, now we can not create it again... We already tried
>>re installing emerald.
>>The message we get is:
>>Create Device Failed.
>>Please Check the Device Settings and Retry.