From: Since_humans_read_this_I_am_spammed_too_much@spamyourself.com   
      
   Erland Sommarskog schreef:   
   > Erwin Moller (Since_humans_read_this_I_am_spammed_too_much@spamyourself.com)   
   > writes:   
   >> No, nobody else is doing thing to the database, only a regular backup   
   >> once a day.   
   >> After Googling around a little I found others that had this problem with   
   >> SQL Server 2000, and the problem persisted even after setting autoclose   
   >> to false.   
   >> Regretably for me, no solutions were posted. :-/   
   >>   
   >> Do you know if the message 'Starting up database' always means it went   
   >> offline before?   
   >   
   > OK, let's double-check. What does   
   >   
   >    SELECT databasepropertyex('yourdb', 'IsAutoClose')   
   >   
   > return?   
   >   
   > And if you do   
   >   
   >    ALTER DATABASE yourdb SET AUTO_CLOSE OFF   
   >   
   > what happens?   
   >   
   >   
      
   Well, I have to contact people to test this.   
   I asked them to set this property in the SQL Manager for the db.   
   Is there any difference between that property setting via SQL Management   
   Console and setting and checking it as you suggest?   
      
   Regards,   
   Erwin Moller   
      
   --   
   "There are two ways of constructing a software design: One way is to   
   make it so simple that there are obviously no deficiencies, and the   
   other way is to make it so complicated that there are no obvious   
   deficiencies. The first method is far more difficult."   
   -- C.A.R. Hoare   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)