Thanks

Yes, there is a minor trigger on it, but that just populates the lastupdated date and DB host name fields, which will use the same values, irrespective of the user...

Thanks for the suggestions, but you may be misunderstanding what I have said.

I am more than fully aware of what causes this error in normal circumstances, trying to put...

jaideep (7/14/2008)

---

James,

Why couldn't we use the sp_attach_single_file_db or create database for attach command if we have the mdf file with no ldf file?

Won't this process be more safe than the...

I've had a few issues with rogue transaction logs as well (on MSDE at any rate). Even on autoshrink I've had them grow to over 10GB, and didn't even notice...

I've had a lot of experience with corrupt transaction logs. We have a client where they put out machines with faulty raid controllers. If the machine lost power, HDD corruption...