If you HAVEN'T tried this already:

Rename the .ldf file (this is important) to something like old_dbname_log.ldf (just add old_  to the name).

Then try the sp_attach_single_file_db command (or it's SQL7 equivelant).

If...

Gotta ask you:

(a data file and a log file), which cannot be attached either via sp_attach_db or sp_attach_single_file_db,

Why not? Did you get error messages when you tried it?

-SQLBill

So are you saying SQL Server is installed correctly but you can't connect to it?

Or is SQL Server not installed?

If it is installed, but you can't connect to it then...

Are there any messages in the Windows Event Viewer logs (application, security, system) that might shed light on this?

-SQLBill

You have to have admin rights on the database. Do you have another account with that privilege? SQL Server (which MSDE is) has the account BUILTIN/ADMINISTRATORS. That account lets anyone...

What all is your maintenance plan doing? Is it also 'defragging' the indexes? This can cause the database to grow also (log space). Shrinking a database (or file) might not have...

COMMIT or anything else will not stop the transaction log from growing. The log keeps track of transactions that happened since the last backup of any kind. If you are...

I haven't tried it yet, but I notice there's no place for the PASSWORD.

On the workstation you are having problems with, can you use that to get to any other...

Somebody changed something. Now you have to figure out what it was.

1. SQL Server collation?

2. The default language? (as Antares suggested)

3. You are using a different PC, which has a...

Aha (maybe)!! Open Enterprise Manager, expand down to the database in question. Right click on that and select Properties. On the General tab, in the Database section, who is the...

An easier way is in Enterprise Manager, go to Security>Logins. Double click on the login and on the Database Access tab in the upper window check the box to the...

Follow Steve's directions and you shouldn't have any problems (if you do, post them and we'll try to help) HOWEVER, you state:

 i gave user name as "sa" and password as...

As James pointed out, this really isn't the proper forum. The Question of the Day (QOD) forum is is strictly for discussing the Question of the Day. The QOD is...

Exactly how were your backups done?

Did you create new backup files or were they appended to, or were they overwritten?

Here's what should have been done:

Full Backup

Transaction Log Backup with INIT...

I was probably remiss in not explicitly pointing out that since the CAST changes it to a DATETIME with a default time of 00:00:00, that will cause this:

2004-06-09(12:00:00.000)

2004-06-09(05:23:58.000)

2004-06-09(23:02:15.000)

Will ALL become:

2004-06-09...