TSQL Function SQL Server 2012
Project Description:
I require someone to prepare a TSQL function that returns the name of the ODBC DSN.
I will use the queries below, to get information about the connection, but none of these return the DSN name for instance.
1. select * from sys.dm_exec_connections
2. select * from sysprocesses
3. select connectionproperty('net_transport')
4. select connectionproperty('protocol_type')