• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1151
  • Last Modified:

sql connectivity

i am running the following:

SELECT program_name, loginame, count(*)
FROM
Master..sysprocesses
WHERE ecid=0 and spid > 50
GROUP BY program_name, loginame
ORDER BY count(*) desc

And i get coming out program name
   MS SQLEM - Data Tools
   Microsoft SQL Server

How do i know if that person is running a copy of SQL Server Client or they are coming in as a odbc connection or something....Basically im trying to figure out what these two are....and what user has access through which application..........
0
TRACEYMARY
Asked:
TRACEYMARY
  • 3
  • 2
1 Solution
 
Atlanta_MikeCommented:
MS SQLEM - Data Tools is enterprise manager.

Not sure you have the whole field for Microsoft SQL Server?

Query Analyzer will say SQL Query Analyzer
0
 
Atlanta_MikeCommented:
And usually if connecte through an ODBC connection the Application connecting through ODBC will be shown. I.e. if using Access 2003, Microsoft Office 2003 (or something similar).
0
 
TRACEYMARYAuthor Commented:
hmm..thats what i was hoping it was not.
So some one has SQL Server Clients intalled on their machines and using SQL Server Enterprise
....let me go to his desk lol.........and *****  ..........

Thanks
0
 
Atlanta_MikeCommented:
Have fun! You can always cut his access :-)
0
 
TRACEYMARYAuthor Commented:
Smiles.........i might just do that ...........lol
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

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