Forcing Users to log out of SQL 2000

Hot Topic

PIVOT statement whitout knowing values
View SQL Sever 2005 Express database on SQL Sever Enterprise Manager
Subscribing to heterogenous data
Hide table owner in Object Explorer?
Filter Question
Error Opening Report in Report Builder
WRITETEXT with select query
Identity field settings not copied by Import Wizard (2005)
Specify column list in Full Text CONTAINS search
How to Get Error Output from and OLE DB Command Destination

SQL Server

problem with installshield
A Clarification required on xp_terminate_process
How to fix postion of report itme?
how to make report parameter value change dynamic when run time?
File share subscriptions with domain users not working
Generating XML based on Schema
Dynamic Scripts
SSEUtil.exe SQL Server Express Utility
Update SQL Server 2005 Install files
Restore a single table

Forcing Users to log out of SQL 2000

I am a begginer to SQL. I am truly limited with SQL language.

Every month we have to do a month end closing for our company. In order for us to do this we need to get everyone off the database to proceed. This process is horrible and generally takes at least 1/2hr to 45 min. to do so. i am looking for a command that i can use in query analyzer if possible to force the users out of the database. if that isnt an option can you recommend another program in which i can do this. i am at a loss and need some help..... thanks



Answer this question

Forcing Users to log out of SQL 2000

  • Serg256

    Did you have a look in the BOL for ALTER DATABASE

    ALTER DATABASE SomeDatabase
    SET SINGLE_USER
    WITH ROLLBACK IMMEDIATE

    or from the syntax with a delay of x seconds:

    <termination> ::=
    {
    ROLLBACK AFTER integer [ SECONDS ]
    | ROLLBACK IMMEDIATE
    | NO_WAIT
    }

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • rgreiser

    ok thank you i will try this at the end of the month

    i do appriciate your time!!

    thanks


  • Hasan9552

    what is the command

    can i use it in query analyze

    thanks again


  • Matthew Kane

    SUre thisis quite easy, the command kills all the user sessions immediately. If you want to wait a respective moment you can use the WAIT FOR keyword, but with the keyword IMMEDIATELY all User will be banned out of the database and their transactions will be roled back (if any transaction is open)

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

  • Anil Dhiman

    i am unsure of what you mean. as i stated i am truly a beginner with SQL.

    can you explain it to me like i am 4 lol

    thanks


  • jvwardle

    You can use it in QA to force the users (as I mentioned before) to log out, current transactions will be rolled back. Make sure if this complies with your maintaince strategy (not every user is pleased to be logged out while he is doing a transaction :-) )

    HTH, Jens Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  • Forcing Users to log out of SQL 2000
Answer this question