Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Location
    Washington, DC
    Posts
    5

    Question Unanswered: sp_locklogin questions, help?

    What is the best method for using sp_locklogin while trying to do nightly maintenance on Sybase ASE 12.5?

    I have applications "out there" that have keep alive processes. These processes are making my nightly maintenance procedures unhappy every night. I would like to bring up Sybase and lock the logins, kill all the user processes (or just bring up Sybase in a mode that will not allow them to login)..

    What is the best method to achieve this?

    Thanks in advance!

  2. #2
    Join Date
    Mar 2001
    Location
    Lexington, KY
    Posts
    606
    or just bring up Sybase in a mode that will not allow them to login
    Bringing up ASE in single-user mode would prevent this, but there may be less drastic options out there.
    Thanks,

    Matt

  3. #3
    Join Date
    Jan 2005
    Location
    Washington, DC
    Posts
    5

    Thumbs up

    Funny you should say that.. Have been pondering that exact idea, just wondering how much it might compromise other peoples' "special bubbles"

    But hey, who am I to complain about that? I think I will try it and see if I can get away with it...


  4. #4
    Join Date
    Jan 2004
    Posts
    545
    Provided Answers: 4
    You can try and use logintriggers. Make one at the desired time, connect them to the appropriate login(s).
    Every time a login connects, kick them off the server for instance.
    After the maintenance, disable the logintriggers, and you're done.
    I'm not crazy, I'm an aeroplane!

Posting Permissions

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