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:
00483639
Views:
9
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform