473,473 Members | 2,126 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Number Of Connection In Sql

1 New Member
hi folks,

i just wanted to know the query tat will find out the no of users logged in sql server
plz help me
Aug 15 '07 #1
1 1097
Purple
404 Recognized Expert Contributor
Hi johnbasha and welcome to TSDN

may I suggest you take a look at sp_who, more info can be found here

Regards Purple
Aug 15 '07 #2

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

Similar topics

4
by: sumithradevi | last post by:
Hello Friends, I am getting the following error. java.sql.SQLException: ORA-00020: maximum number of processes (100) exceeded I am closing all my resultsets and all my connections in the try...
3
by: Mettá | last post by:
I was given the basics of the code below to display an Access DB. Can anyone tell me how to limit the number of db records that come up using the code below... Thanks M <%Dim DSN_NameX...
3
by: Clemens Chiba - Greentube I.E.S. AG | last post by:
Hi! If the user has no LAN connection I have to dialup to the internet in my application. This works fine, but in some case I'll have to change the phone number (if the provider changes) and the...
1
by: mike g | last post by:
Hello, I have postgres set to log all connections. I run it on port 5432. I have noticed in the postgres logs that the port being used to connect to the database is logged but never equal to...
3
by: Jason | last post by:
If I've got a string like x = " Intel(R) PRO/1000 CT Network Connection" How do I get x = "Intel(R) PRO/1000 CT Network Connection" I basically want to make a comparison to Intel(R) PRO/1000...
10
by: CJM | last post by:
I'm trying to call a package/procedure in oracle (from an ASP page) which requires a number of parameters. I have got this working using OO40 but unfortunately the transaction rollback function...
5
by: alingsjtu | last post by:
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected...
1
by: tensi4u | last post by:
Hello, everyone. I began to work with DB2 V8.1 for Linux on debian from last month, I'm beginner to DB2, and I have two questions. First, searched articles related to "number of connection" at...
1
by: anneaunimme | last post by:
I have a program which allow my computer to communicate to another device using an ethernet Cable. The thing is that this program is set so that it can only work through a specific IP address and a...
1
by: -pb- | last post by:
Hi, Following is our different database infrastructure. Server1 on NetwrokDomain1 SQL Server 2000 Server2 on NetwrokDomain2 SQL Server 2000 The database on Server2 is being used by third...
0
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,...
0
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,...
1
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...
0
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
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...

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.