Post reply

List of ODBC connections

  • March 14, 2017 at 3:32 am

    #401780

    Dear All,

    I'm trying to find out list of ODBC connections on SQL SERVER but I'm not sure which script or process to get the list please?

    Thanks in advance!

  • March 14, 2017 at 4:27 am

    #1933003

    tt-615680 - Tuesday, March 14, 2017 3:32 AM

    Dear All,

    I'm trying to find out list of ODBC connections on SQL SERVER but I'm not sure which script or process to get the list please?

    Thanks in advance!

    This should get you started
    😎

    SELECT
    *
    FROM    sys.dm_exec_sessions    SDES
    WHERE    SDES.client_interface_name    =    N'ODBC';

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply