Re: Emerald Database

Dale E. Reed Jr. ( (no email) )
Thu, 20 Aug 1998 11:41:16 -0700

Humberto Guzman wrote:
>
> Tried it...
>
> got the following message:
> Msg 911, Level 16, State 2
> Attempt to locate entry in Sysdatabases for database 'emerald' by name
> failed -
> no entry found under that name. Make sure that name is entered properly.
> Msg 15010, Level 16, State 1
> The database 'Emerald' does not exist. Use sp_helpdb to show available
> databases.

You need to delete the physical file on your disk. Its called
Emerald.dat, and typically in your \mssql\data directory.

--Dale E. Reed Jr.  (daler@iea-software.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com