patternMinor
What would I look for in SQL Server to determine if a user connected with Microsoft Access?
Viewed 0 times
whatsqluserwithlookmicrosoftwouldconnectedfordetermine
Problem
Is there a way I can check SQL Server to see who is accessing it using Microsoft Access (as opposed to a website)? I'm using SQL Server 2008R2 with the default logging settings.
Solution
The sp_who2 stored procedure lists all active connections and includes the ProgramName.
You could also select from sysprocesses (joining in whatever other information you require such as sysusers) but it's just easier to use sp_who2.
(caveat, this will only work for applications which set the name, some applications may not)
You could also select from sysprocesses (joining in whatever other information you require such as sysusers) but it's just easier to use sp_who2.
(caveat, this will only work for applications which set the name, some applications may not)
Context
StackExchange Database Administrators Q#8253, answer score: 3
Revisions (0)
No revisions yet.