Re: How to close all concurrent connections to a database?
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 11/11/04
- Next message: Hari Prasad: "Re: How to get all users permissions on different objects of a database in a query"
- Previous message: Le Hoang Anh: "How to close all concurrent connections to a database?"
- In reply to: Le Hoang Anh: "How to close all concurrent connections to a database?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 10 Nov 2004 22:13:53 -0600
Hi,
You can execute:
ALTER DATABASE MyDatabase SET SINGLE_USER WITH ROLLBACK IMMEDIATE
and after the task u can set the database to multi user
ALTER DATABASE MyDatabase SET MULTI_USER
-- Thanks Hari SQL Server MVP "Le Hoang Anh" <mr_khas@yahoo.com> wrote in message news:uDKfdv5xEHA.3624@TK2MSFTNGP09.phx.gbl... > Hi all, > I'm wondering how to detect and close all concurent connection to a > database in SQL Server 2000. Could anyone give me a solution, plz? > Thanks! >
- Next message: Hari Prasad: "Re: How to get all users permissions on different objects of a database in a query"
- Previous message: Le Hoang Anh: "How to close all concurrent connections to a database?"
- In reply to: Le Hoang Anh: "How to close all concurrent connections to a database?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
