Home Forums SQL Server 2005 Administering Message "Starting up database " everyday in SQL Server log RE: Message "Starting up database " everyday in SQL Server log

  • Here is the simple statement you can use to turn of Auto close option, just change the database name.

    ALTER DATABASE MYDATABASE SET AUTO_CLOSE OFF