>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