Jeff Moden (12/1/2014)

---

Not sure (didn't test the code) because you didn't provide any readily consumable data but I believe this should be pretty close to what you're looking for...

SELECT...

Ill try it .

I have the week number there should be a way to get the Monday for that week.

Thanks

Thanks but I am still having issues. I have a back up of MSDB from the other sql installation which contains the job info. So I try to...

I solved it, here's the result in case anyone wants it:

DECLARE @SQLString NVARCHAR(4000)

SET @SQLString = 'SELECT '+'X*1200'

set @SQLString = REPLACE(@SQLString, 'X', '3')

EXEC sp_executesql @SQLString

We are replacing the X with the...

Installed SP1 and now the flat file option is there.

It Worked!

You are a genius!

Heres what I did:

Folowed the steps you said to re attach it.

Restored backup from feb 15th and transactions since then.

Everything is up no loss

Thank you very...

Thanks

The only problem is it will not let me reattach.

When I try to reattach it tells me error run CHECKDB

Then it wont let me run checkdb because the...

Thanks - 1 more question:

I have a full back up from Feb 15th and Differential backups up untill last night.

How can I restore? My database is no longer attached...

Actually I did not DELETE the LDF i saved it in another folder so I still have it. But when I try to attach it it gives me error...

I tried sp_resetstatus 'mydatabase' and tells me the database does not exist.

This database was detached after it became suspect. Now it does not even show up in enterprisse...

I forgot to mention this is a SQL2000 database