| Adi Cohn 2002-11-11, 9:23 am |
| I assume that you are talking about a user database that you wanted to run
the integrity check. If this is the case, then you don't need to have the
server in a single user mode. Instead you need set the DATABASE to a single
user mode. Check out sp_dboption in BOL to see how to set a database (not a
server) into single user mode
Adi
"Tony" <tony@burgessfurniture.com> wrote in message
news:3dcfb3b4_3@news2.vip.uk.com...
> I have had some trouble running integrity checks and the log is aysing the
> database needs to be in single user mode - Fine
>
> So I start the SQLSERVER service using the -f parameter, then run the job
> which then tells me I need SQLSERVERAGENT running which I then start.
>
> Then when I try to access the database I get a message saying :
>
> "Logon failed for user BURGESS\Administrator. Reason: Server is in single
> user mode. Only one administrator can connect at this time."
>
> If it is any help:
> I log on to the Win2000 server using BURGESS\Administrator
> Both Services are set to the Local for logon purposes.
>
> Any help would be appreciated..
>
> Tony
>
>
>
>
>
>
>
|