I'm am looking to find out if there is a way to write a
script that will lock all but one user out of a database.
We have a reporting database that if queried while the
database is being updated would yield inacurate /
logically, I can figure it out:
If users not XYZ Then Kill users
I just don't know how to write it. I've used Books Online
and a few other sources but can't seem to find syntax on
how to kill user connections.
Thanks in advance for any help.