A couple of months ago, one of my clients installed Microsoft SQL Server 2008 R2 Express. While I was looking at the log last week, I saw something really strange.

This message was repeated continuously in the logs:

“Starting Up Database ‘xxx’”

If like me, you are using a SQL Server Express database in a multi-user environment, you should really consider switching your AUTO_CLOSE setting to off. You will find this setting in the properties of your database under Options.

You can also use this T-SQL statement:

ALTER DATABASE YourDB SET AUTO_CLOSE OFF