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:
00484285
Vues:
13
>I don't know about you Mike, but after thinking about it, and while it is possible, I would not do this at all... I would rather work from the server and manually take care of the tasks needed. You can't guarantee what you may screw up by killing someone's connection.

While I tend to agree with you, there are situations where the business process may call for this. There's no way to speculate what may happen if you killed the connection. It would depend on how the application was written. If all changes are enclosed with a transaction, then there might not be any issues since SQL Server would rollback all uncommitted changes.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform