Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need to close all client connections to server
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
00483519
Message ID:
00483639
Vues:
10
>Hi All :
>
>I Need to close all client connections to the server, so that a can update some or all tables, but this could happen when some client pc as a connection.
>The goal is to close all other connections, but keep mine open !
>(I'm the 'sa')
>
>Can anybody help me ?
>
>TIA

If you start SQL Server with the -m switch, it starts in single-user mode. This will allow you to connect and perform maintenance.

HTH
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform