|
| PORTAIL | ANNUAIRE | ARTICLES | COMPARATEUR HÉBERGEURS | DEVIS | FORUMS | RÉDUCTEUR D'URL |
|
|
|
|
||||||
| ms.sqlserver.setup Questions about SQL Server. |
 |
|
|
LinkBack | Outils de la discussion |
01/03/2007, 20h17
|
#1 |
Messages: n/a
Hébergeur: |
Kill spids , set DBA and single user mode
Looking for script to kill all users in theDatabase and set to DBO and
Single user Mode. |
|
|
01/03/2007, 21h18
|
#2 |
|
Messages: n/a
Hébergeur: |
Re: Kill spids , set DBA and single user mode
Hello,
The below command will set the database to single user mode after removing all users. ALTER DATABASE <DBName> Set SINGLE_USER WITH Rollback Immediate Thanks Hari <msnews.microsoft.com> wrote in message news:uEbI5YDXHHA.4880@TK2MSFTNGP05.phx.gbl... > Looking for script to kill all users in theDatabase and set to DBO and > Single user Mode. > |
|
|
|
| Outils de la discussion | |
|
|
