Here are the "full" directions.

1. Open Query Analyzer

2. sp_detach_db ‘database-name'

· Open Enterprise Manager

· Management

· Locks/Objects

· Kill any processes that are making the db "in-use"

· Repeat step #2

3. Delete the log file

4. Open Enterprise Manager

5. Right Click “Databases”

6. Left Click”All Tasks”...

No, everything should be OK.

Please do the following if you get a "database currently in use" message when doing step #2

2b. Open Enterprise Manager

2c. Management

2d. Locks/Objects

...

How to reduce the log file size:

1. Open Query Analyzer

2. sp_detach_db 'database-name'

3. Delete the log file

4. sp_detach_db 'database-name'

5. Open Enterprise Manager

to make sure the database works