Hi!

I have a problem. I'm running SQL Server 2000, and I've detached a Database using the Enterprise Manager in order to free some space, then I've deleted the Log file for that database, and then I've tried to attach the database, and this is when I recieve an error:

---------------------------
Microsoft SQL-DMO (ODBC SQLState: 42000)
---------------------------
Error 1813: Could not open new database 'SYSDB'. CREATE DATABASE is aborted.
Device activation error. The physical file name 'E:\Databases\SYSDB_log.ldf' may be incorrect.
---------------------------
OK
---------------------------


I've done this many times in SQL 7.0 even though it only can be done by the SQL Query Analizer, but never had this issue.

I've tried to execute the sp_attach_single_file_db Stored Procedure but I get the same error.

I really need some help with this,
what can I do to solve this problem? or, if there's no solution, what's the proper way to delete the log file of a database in order to re-create it?

Any help would be appreciated.
Thanks in advance!