Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Logging off users Programmatically...

Status
Not open for further replies.
AWEinCA

AWEinCA

Programmer
Oct 18, 2000
35
US
Is there a way to disconnect all currently connected users through a stored procedure except the connection that called the stored procedure?

[sig][/sig]
 
Sort by date Sort by votes
You could run sp_who, then loop through the results using KILL to kill the connections, but not KILLing @@spid. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

asmall
  • Locked
  • Question
Users Not Assigned to a Group
Replies
1
Views
137
johnherman
johnherman
PeDa
  • Locked
  • Question
Identfying current users of database
Replies
4
Views
150
PeDa
PeDa
SBTBILL
  • Locked
  • Question
MSSQL says there are other users when there aren't 2
Replies
4
Views
218
gbaughma
gbaughma
DougNaf
  • Locked
  • Question
Domain users connected to SQL database
Replies
2
Views
168
NoCoolHandle
NoCoolHandle
onyxtacular
  • Locked
  • Question
updating Boolean based off character and character location
Replies
1
Views
100
onyxtacular
onyxtacular

Part and Inventory Search

Sponsor

Back
Top