General discussion

Locked

SQL Sessions

By kaypaul ·
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.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Tony Hopkinson In reply to SQL Sessions

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.

Collapse -

by kaypaul In reply to

Poster rated this answer.

Collapse -

by kaypaul In reply to SQL Sessions

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums