Post reply

SQL Native Client - How can you tell it's being utilised as a connection?

  • July 30, 2013 at 2:53 am

    #275740

    Hi All,

    Apart from turning it off with all of the associated protocols, how can you tell it's being used?

    Thanks in advance

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

  • July 30, 2013 at 7:09 am

    #1636967

    Without knowing anything about your environment, there really isn't a good way to determine this 100% (unless I'm not understanding your question). The native client drivers are just that...drivers. They aren't actual connections themselves, they just help things that want to connect to SQL instantiate connections. I'd probably throw up a Profiler trace and see if there's a way to separate out the connections that use the native drivers versus other connections that are used in your environment (maybe by including the calling app name/user name/etc to give you a clue on where to start looking).

    -G

  • July 30, 2013 at 10:10 am

    #1637061

    Thanks for the response

    SQL DBA
    Every day is a school day, and don't trust anyone who tells you any different.
    http://sqlblogness.blogspot.co.uk

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

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