Networks
How can I logoff user sessions on SQL at a certain time of the day?
As I need to run a batch and don't want any users
connecting to the SQL.
Like you here's me looking for sp_kill @spid. No such thing apparently. Haven't tries it but this fella says the solution is
http://www.developerkb.com/modules/wfsection/article.php?articleid=27
I should point out though this won't stop people connecting during your sp. It would probably be better to shut the server down, run it up as exclusive, do your stuff and then restart it normally.
Poster rated this answer.
This discussion is closed to new replies.
Sort by Trending