Re: Prohibit User Logons

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 06/23/04

Next message: Tibor Karaszi: "Re: Changing Database Owner"
Previous message: Ric: "Installing SQL and using DTS between domains"
In reply to: Ray Price: "Prohibit User Logons"
Next in thread: Hari: "Re: Prohibit User Logons"
Messages sorted by: [ date ] [ thread ]

Date: Wed, 23 Jun 2004 11:57:47 -0400

Place the database in single user mode.

-- 
Andrew J. Kelly  SQL MVP
"Ray Price" <ray.price@gartner.com> wrote in message
news:%2393S3NTWEHA.644@tk2msftngp13.phx.gbl...
> What is the best way to prohibit user logons whilst performing maintenance
> on the server?
>
> Regards
>
> Ray
>
>

Next message: Tibor Karaszi: "Re: Changing Database Owner"
Previous message: Ric: "Installing SQL and using DTS between domains"
In reply to: Ray Price: "Prohibit User Logons"
Next in thread: Hari: "Re: Prohibit User Logons"
Messages sorted by: [ date ] [ thread ]

Relevant Pages

Re: Sqlmaint.exe problem
... You can use sp_dboption to place the db in single user mode ... > Well Andrew, I am listening... ... >> want to automatically repair errors without first determining what they ... >> Andrew J. Kelly SQL MVP ...
(microsoft.public.sqlserver.tools)
Re: integrity check error and single user mode on Project Server d
... I changed my integrity check to not attempt to repair any minor ... and it doesn't require single user mode to do the check. ... >> Andrew J. Kelly SQL MVP ... >>> DATABASE statement failed. ...
(microsoft.public.sqlserver.server)
Re: how to increase /tmp RedHat Linux 8
... Just swap it for a soft link to somewhere with more space. ... Do it in single user mode, then re-boot. ... Andrew wrote: ...
(linux.redhat)