MS SQL RSS MS SQL RSS

Question?

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

•
•
Join Date: Dec 2008
Posts: 2
Reputation: mcarloskewl is an unknown quantity at this point 
Solved Threads: 0
mcarloskewl mcarloskewl is offline Offline
Newbie Poster

Question?

 
0
  #1
Dec 3rd, 2008
i have a project of Call Management System with database SQL SERVER,now i want to limit the connected users in my database in 55 connected users only,where in this 55users can only use the system and if there is 1 user trying to connect on my database the system will no longer accepting this User. and if every user will log out the connected users should be decrement.
Last edited by mcarloskewl; Dec 3rd, 2008 at 9:14 pm.
Reply With Quote Quick reply to this message  
•
•
Join Date: Feb 2008
Posts: 42
Reputation: huangzhi is an unknown quantity at this point 
Solved Threads: 13
huangzhi huangzhi is offline Offline
Light Poster

Re: Question?

 
0
  #2
Dec 3rd, 2008
You can use table master.dbo.sysprocesses.
This system table contain connected users.
Last edited by huangzhi; Dec 3rd, 2008 at 11:47 pm.
Hence Wijaya
www.ex-Soft.tk
Reply With Quote Quick reply to this message  
Reply

Quick Reply to Thread
This thread is more than three months old.
Perhaps start a new thread instead?
•
•
•
•
•
•
•
•
Message:
•
•
•
•



Similar Threads
Other Threads in the MS SQL Forum
Thread Tools Search this Thread



connectingtodatabaseinuse count cursor database datepart deadlock delete_trigger highperformancecomputing hpc hpcserver2008 ibm iis loop maximum microsoft ms multithreading news number permission query result server sets sql sqlserver sqlserver2005 supercomputing uniqueid update view
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC