Whats the SQL Server version and serv pack? Are you running any db
maintenance plans?If so, try removing the "fix minor problems" in you
maintenance plans.I believe this was fixed in SQL 7 SP3.
SQL Server FAQ at
"george d lake" <georgelvalleyyellowpages.com> wrote in message
> Today when I came in to work I noticed errors on our Intranet that
> SQL related.
> I found that the Database was set to "Single User". I had to go into
> properties/options and disable the "Restrict Options" check box.
> This seemed ...