Re: Single user mode question.

On Jun 20, 7:12 pm, ThanksButNo <no.no.tha...@xxxxxxxxx> wrote:
On Jun 20, 2:20 pm, Serguei <Serguei.Goumeni...@xxxxxxx> wrote:

    Dear Experts,

I inherited a script written long ago and the first line is to check
is the Sybase server in the single user mode or not. I personally
never make this test, but may be I am wrong.

Question: Is it a good practice for the Sybase server to check what
mode is it running?

Some things an administrator has to do, he has to do without any
risk that some other user might log on and mess things up.

E.g., you might need to re-work the syslogins and sysusers tables
because those have a habit of getting out of sync.  You don't
want to do that sort of thing while somebody else is logged in,
and you don't want somebody to log in while you're in the middle
of doing that.

An administrator might want to put some of those kinds of things
into a script to make his life easier.  Why wouldn't such a script
check for single-user mode first thing?

\:-\

Thank you for your reply, but you do not answer my question. I like to
know - is it a good (recommended) practice for a Sybase user to test
which mode the server is running?

Regards,
Serguei.
.

Relevant Pages

  • Re: Single user mode question.
    ... I inherited a script written long ago and the first line is to check ... is the Sybase server in the single user mode or not. ... Is it a good practice for the Sybase server to check what ... Some things an administrator has to do, he has to do without any ...
    (comp.databases.sybase)
  • Re: SP4 error running replsys.sql
    ... does appear to be a single user mode race issue (not color for you ... We had to devise a work-around to get it to work (SQL Server SP4 if it ... failed on the replsys.sql script). ...
    (microsoft.public.sqlserver.setup)
  • Re: SP4 error running replsys.sql
    ... clicked Yes to run the Replsys script but it still bombed out. ... Any other suggestion on how to install SP4? ... try to connect to a single user mode instance. ... I had a case open with Microsoft and they had no clue. ...
    (microsoft.public.sqlserver.setup)
  • Re: Nut and RAID on FreeBSD 7.0
    ... >> single user mode and run a script that delayed for some time longer ... >> shutting down to single user mode. ... Plus a similar message for going to battery power. ... Executing upssched from the command line it tells me ...
    (freebsd-questions)
  • RESOLVED: SP4 Installation Problem on Win2000/SQL Enterprise Edit.
    ... Reason: Server is in single user mode. ... Only one administrator can connect at this time. ...
    (microsoft.public.sqlserver.setup)