TSQL Function SQL Server 2012

  • Status Closed
  • Budget $30 - $250 USD
  • Total Bids 7

Project Description


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.

[url removed, login to view]

Could you quote for writing a function that I can use from TSQL code that returns the name of the DSN?

Thank you

Get free quotes for a project like this
Awarded to:

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online