March 9, 2009 at 11:56 pm
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
March 10, 2009 at 12:55 am
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]
March 10, 2009 at 7:01 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply