sql connectivity

Posted on 2006-06-08
Last Modified: 2012-06-27
i am running the following:

SELECT program_name, loginame, count(*)
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..........
Question by:TRACEYMARY
    LVL 13

    Expert Comment

    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
    LVL 13

    Accepted Solution

    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).
    LVL 7

    Author Comment

    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 *****  ..........

    LVL 13

    Expert Comment

    Have fun! You can always cut his access :-)
    LVL 7

    Author Comment

    Smiles.........i might just do that

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    755 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

    21 Experts available now in Live!

    Get 1:1 Help Now