Jonathan Kehayias (5/27/2009)
When you attach without the log file, it is rebuilt, which can leave your database incosistent, not a good thing to do.
I don't even think you can attach a database without a transaction log if the database wasn't shut down in a clean manner, and by that I mean that there would be no need for rollback or roll forwards during startup.
So if you delete the transaction log file and the database was not shut down properly there is no chance in h*** you can attach the database again.
Or am I missing something? Not that I would ever do something like that.