Question?

Expand Post »

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.

Similar Threads

C command-line I/O question in C++
Apache Alias Directive... mod_alias question in Linux Servers and Apache
Completely new to C++ and have question about using char in C++
Question in Geeks' Lounge
question on cooling in Cases, Fans and Power Supplies

mcarloskewl

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Dec 2008

Permalink

Dec 3rd, 2008

Re: Question?

You can use table master.dbo.sysprocesses.
This system table contain connected users.

Last edited by huangzhi; Dec 3rd, 2008 at 11:47 pm.

huangzhi

Reputation Points: 10

Solved Threads: 13

Light Poster

Offline

48 posts
since Feb 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Added Dependencies?

Next Thread in MS SQL Forum Timeline: I would like to get the result for a particular query using cursor in transaction

DaniWeb Message

Cancel Changes

User Name
Password