Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 139
  • Last Modified:

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

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
branuda
Asked:
branuda
3 Solutions
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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
 
Aneesh RetnakaranDatabase AdministratorCommented:
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
 
ste5anSenior DeveloperCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now