I need someone to write a TSQL function that returns the name of the ODBC DSN.
I can use the queries below, to get information about the connection, but none of these return the DSN name for example.
1. select * from sys.dm_exec_connections
2. select * from sysprocesses
3. select connectionproperty('net_transport')
4. select connectionproperty('protocol_type')
This link shows the C# class that may be able to return this information.
Could you quote for writing a function that I can use from TSQL code that returns the name of the DSN?