473,563 Members | 2,732 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

To know how many clients connected to SQL server

1 New Member
Hi
I m using SQL server database and i wanted to know how many clients are currently connected to SQL server.
Oct 26 '07 #1
1 1868
sing4you
3 New Member
Run sp_who2 in the Query Analyzer, and you'll see all connections.
Oct 26 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

2
2567
by: Filippo | last post by:
Hi, i have a problem about the CLIENT-SERVER architecture procedure. Well , i have an application in VB with ADO connection to a table in a database on a SQLSERVER 7.0 . Is possible to do that when a client updates a data in a field of my table , the SERVER communicates to all clients connected to my table that this data are updated ,...
1
1804
by: Sanjit Suchak | last post by:
Hi, I am just learning about .net remoting and have managed to get it working. However, I now want to write a basic chat program. The problem I've got is getting the server to only fire events to some of the clients. eg. Client 1 and Client 2 are connected to the Server
0
838
by: digibyte | last post by:
I have the following situation: A server is connected with a modem to the telephone line. When someone calls me, the server receive the "caller ID". Now I want that information on all my clients who are logged in. So, a client log in to the server and receives an message (caller ID) when someone calls. Should I make use of the...
0
2335
by: Philippe Lang | last post by:
Hello, After using Postgresql for a while, through ODBC / MS Access, I'm not able to connect to the server anymore. The server reports "Too many clients connected already". With a "ps -afx", I can see a lot of idle postgresql connections, which correspond for sure to ODBC connections that haven't been closed properly, and that remain...
4
1746
by: baramuse | last post by:
Hi all, before starting I must say that I'm a remoting beginner so I certainly didn't assimilate all the tricks of remoting so please be kind ;) Now here is my interrogation: I'm working on a client/server architecture for a callcenter software. The server is the only one connected to the oracle database and all the different clients...
5
2770
by: Cichy | last post by:
Hello, I'm writing a Client-Server application using sockets (asynchronous). There is a Server (Master) which accepts incoming connections, and Client (Slave). Afetr establishing connections with all Slaves I wanna hit a button "Automatic", then everything must be reorganised, there is an ellection for a new Master. Everything is all...
4
3322
by: setiarakesh | last post by:
I have designed a socket Server and developed asynchronous server . It is working fine with 60 Clients which are connecting to ths Server running at Machine (2 GB RAM and OS is Windows 2003 Server)having IP which is Mapped with static IP and Port in firewall . The Programme is working fine with 60 clients and rate if incoing data on the...
1
1835
by: kurrachaitanya | last post by:
Lecture Saying that: I am generally expecting most of you to work n java.If you prefer to use c/c++ version of the programs,you may,but the assistance in the lab sessions will be very much geared towards java user. compile both the client and the server programs.open two shell windows on different machines(using e.g ssh or putty to log into...
1
1507
by: kurrachaitanya | last post by:
YOUR TASK IS AS FOLLOWS : The server is written in such a way that only one client can connect to it at any time.modify the server sothat several clients can be connected to it(and later disconnect from it) simultaneously.In other words,the server should be able to maintain open TCP connections to several clients. when a client sends a string to...
0
7664
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7885
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8106
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7948
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2082
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1198
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
923
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.