Re: Database set to Single User? How?

From: Dinesh.T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 07/02/03 

Date: Wed, 2 Jul 2003 10:27:25 -0500

George,

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. 

-- 
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"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: 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)
  • Re: SQL 2000 after upgrade to server 2003 from NT4
    ... Try to change the owner for each job to "sa". ... > Within the SQL Enterprise Manager under Management->Database Maintenance ... > SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan ...
    (microsoft.public.sqlserver.setup)
Quantcast