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