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.
mcarloskewl
0
Newbie Poster
huangzhi
0
Light Poster
You can use table master.dbo.sysprocesses.
This system table contain connected users.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.