list of tables/ views in the databases that have a direct ODBC connection

• sps-554505

  Default port

  Points: 1463

  More actions

  March 9, 2009 at 11:56 pm

  #129566

  is there any method to find out the list of tables/ views in the databases that have a direct ODBC connection to the database

  can any one hlep me

  Regards,

  Shine

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  March 10, 2009 at 12:55 am

  #956594

  There is no such thing as "a table with a direct ODBC connection to the database". That does not make sense in the context of SQL Server. Can you please explain your question a little more?

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  March 10, 2009 at 7:01 am

  #956744

  Are you sure that all you care about is ODBC connections?

  You can see what is connected and by what interface (.NET, ODBC) by querying sys.dm_exec_sessions. You could probably continue on and join to some other DMV's to get to queries and objects.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question