Thanks, that did the trick.  BTW, the actual SQL steps were being handled by Data Protector and I had no access to that...

I appreciate all the replies, we have now decided to re-install the WSUS server and have it rebuild the database for us.  This time it will be added to the...

When I had EM open, the SUSDB database had SUSPECT beside it in the EM.  In the article it said to detach using the following command.  I substituted my db...

No typos, there is enough drive space and I get same error on 2 different sql servers

SP attach single file simply fails everytime with the 1813 msg

So going to a...

Have not changed the mdf file name, only the drive and or folder they were located in.  In the last try on the test SQL server moved it to the...

Moved mdb file to a different sql2000 test server.  Ran the attach single file SP on this server and got the same error shown below as before on the other...

Moved the log file to a different drive.  Created a new folder for the mdf file and put it in there

Ran the attach single file SP and got this error

Server:...

Tried both replies with same error number as result

Both keep wanting the log file and I never get the prompt to create the new log file from EM.  At this...

Great Info!

Worked like a charm!

Thanks again for all the help!!!

Using the create SQL task, does this duplicate the SQL account assigned to the database as owner?

Thanks again

Does this give you the chance to rename the database?

My mistake, it was MSDE 2000 A sql install

quote:

---

quote:

---

Just a question from the curious..

You talk about subnets, but nowhere do I...

Thanks Jonathan, you put me on the right track, i ended up doing a distinct select into a temporary table and then another distinct select on that table to finally...

I am bound to the ip in one column due to a program we run that uses this table

here is sample of what I have

table workstations

ws_id, ip_address, user_name, etc...

1, 192.168.10.10,...