We had a similar problem with a client running a Commerce Server Application.  Every time the optimizations task ran, the web application would be unavailable because the web application was...

I have had this problem connecting via Enterprise Manager using Windows authentication after changing the sql startup account.  It does not always occur and sql server...

If you have Enterprise Manager open with the Database highlighted and have Query Analyzer open accessing this database, you will get this error. Minimally, highlight a different database in...

When I receive that message, I back up the log two or three times in quick succession and then shrink the file.