Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need to close all client connections to server
Message
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00483519
Message ID:
00484285
Views:
14
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform