Re: Database set to Single User? How?

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 07/02/03 

Date: Wed, 2 Jul 2003 17:29:11 +0200

Check if KB article 259551 at
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B259551 applies
to your case. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"george d lake" <georgel@valleyyellowpages.com> wrote in message
news:uptxprKQDHA.3700@tk2msftngp13.phx.gbl...
> Hi,
>     Today when I came in to work I noticed errors on our Intranet that
were
> SQL related.
>     I found that the Database was set to "Single User". I had to go into
the
> properties/options and disable the "Restrict Options" check box.
>     This seemed to happen at midnight. No one seems to done it here. Is
> there a way for this "just to happen"? or is it a "failsafe" when some
> errors occurred?
>     I cant find anything in the event logs that might indicate an error.
>
>     Anyone with ideas?
>
>     Thanks.
>     George.
>
>

Relevant Pages

  • Re: Change Admin PSW...
    ... Control Panel - Services). ... FAQ from Neil & others at: http://www.sqlserverfaq.com ... for SQL Server professionals - http://www.sqlpass.org ...
    (microsoft.public.sqlserver.security)
  • Re: Export to txt
    ... object with the BulkCopy object in SQL-DMO. ... Looking for a SQL Server replication book? ... george collins wrote: ... > Dim FileSysObject ...
    (microsoft.public.sqlserver.server)
  • RE: SQL server 7.0 Sp3 vuneriabilities
    ... Hi George, ... Slammer virus does not affect SQL Server 7.0. ... it is recommended to install latest service pack to fend off any ... I have found the following relevant articles for your reference: ...
    (microsoft.public.sqlserver.security)
  • Re: The select statement is in a field
    ... George o writes: ... I inherited this database and there is a field that stopres a select ... Is there anyway possible to execute the value of the field ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • RE: Good Book on Datawarehousing with SqlServer?
    ... 2)MDX solutions with Microsoft SQL server Analysis Services By George ... 3)Microsoft OLAP solutions by George spofford,Erik Thomsen & Dick chase ...
    (microsoft.public.sqlserver.datawarehouse)
Quantcast