Solved

Best methodology for determining who is using a shared SQL database.

Posted on 2014-10-24
3
125 Views
Last Modified: 2014-10-29
Client has an application with an executable that may be run from anywhere - no registry footprint at all.  Need to determine who is in the application.  The back end SQL database is shared among all users.
0
Comment
Question by:branuda
3 Comments
 
LVL 45

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 167 total points
ID: 40402308
You can run the following query that returns all actual connections.
sp_who2

Open in new window

The ProgramName column should inform you who's connected by the application.
0
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 167 total points
ID: 40402310
if the application is directly connecting to sql (not using an application /web server ) then, yoi can run sp_who2 and see the host name
0
 
LVL 32

Accepted Solution

by:
Stefan Hoffmann earned 166 total points
ID: 40402350
Need to determine who is in the application.

This is not possible. Cause Currently connected and who is in the application are two different things. Maybe in reality nearly the same and sufficient, but not congruent.

But the others already showed you how to determine who is currently connected to your SQL Server database.
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now