Professional Web Applications Themes

Database set to Single User? How? - Microsoft SQL / MS SQL Server

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 [url]http://www.tkdinesh.com[/url] "george d lake" <georgelvalleyyellowpages.com> wrote in message news:uptxprKQDHA.3700tk2msftngp13.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 ...

  1. #1

    Default Re: Database set to Single User? How?

    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
    [url]http://www.tkdinesh.com[/url]

    "george d lake" <georgelvalleyyellowpages.com> wrote in message
    news:uptxprKQDHA.3700tk2msftngp13.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.
    >
    >

    Dinesh.T.K Guest

  2. #2

    Default Re: Database set to Single User? How?

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

    --
    Dejan Sarka, SQL Server MVP
    FAQ from Neil & others at: [url]http://www.sqlserverfaq.com[/url]
    Please reply only to the newsgroups.
    PASS - the definitive, global community
    for SQL Server professionals - [url]http://www.sqlpass.org[/url]

    "george d lake" <georgelvalleyyellowpages.com> wrote in message
    news:uptxprKQDHA.3700tk2msftngp13.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.
    >
    >

    Dejan Sarka Guest

  3. #3

    Default Re: Database set to Single User? How?

    SQL 2000, and I want to say latest SP.
    I disabled the maintenance plans for now.
    I saw a post from some time ago after I posted mine.

    I was just scarry!

    "Dinesh.T.K" <tkdineshnospam.mail.tkdinesh.com> wrote in message
    news:u4exy5KQDHA.3192TK2MSFTNGP10.phx.gbl...
    > 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
    > [url]http://www.tkdinesh.com[/url]
    >
    > "george d lake" <georgelvalleyyellowpages.com> wrote in message
    > news:uptxprKQDHA.3700tk2msftngp13.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.
    > >
    > >
    >
    >

    george d lake Guest

Similar Threads

  1. Single License - still 2 computers, same user?
    By gallery in forum Macromedia Contribute General Discussion
    Replies: 0
    Last Post: May 11th, 09:13 PM
  2. Replies: 2
    Last Post: July 14th, 05:30 PM
  3. OS X and single user
    By Scott in forum Mac Applications & Software
    Replies: 8
    Last Post: July 7th, 10:57 PM
  4. Replies: 4
    Last Post: July 1st, 06:01 AM
  5. Help:RAC and single instance standby database
    By cs charlie in forum Oracle Server
    Replies: 1
    Last Post: December 27th, 09:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139