Results 1 to 2 of 2

Thread: mssql 2000 kill all user connection for restore

  1. 04-22-2004, 05:45 AM #1
    trapezz
    trapezz is offline Registered User
    Join Date
    Apr 2004
    Posts
    1

    mssql 2000 kill all user connection for restore

    i need a sql statment or procedure to kill all user connection to one database.
    And Deny new connection for a little time.
    So i can a restore this database from a dump.

    I can this do only in exclusiv modus. without any other connection.

    Can anybody help me??

    thanks and best regards from Berlin, Germany
    Reply With Quote Reply With Quote
  2. 04-22-2004, 07:54 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    --usp_killprocess
    --refer this link below.

    http://www.databasejournal.com/featu...le.php/2174031
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules