In Progress

TSQL Function SQL Server 2012


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

Skills: .NET, C# Programming, Database Administration, SQL

See more: tsql dsn, quote about writing, c sharp library, Writing SQL Queries, code sys, TSQL, sql odbc, MICROSOFT SQL SERVER, dsn, system library sql, link sql, write sql queries, sql library, queries sql, microsoft server 2012, microsoft search server sql server, net quote system, sql connection, sql server connection, net programming sql server, aspx server, sql class, sql server programming net, sql server odbc, sharp sql server

About the Employer:
( 29 reviews ) London, United Kingdom

Project ID: #5029530

Awarded to:


Hi, I hope i can solve your issue.. I am having 7+ years of expereince. Looking forward to your positive reply. Thanks, Priya

$50 USD in 1 day
(16 Reviews)

6 freelancers are bidding on average $97 for this job


Hi, I'm very interested helping you creating your TSQL function, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some sa More

$100 USD in 3 days
(33 Reviews)

This article might help you. [url removed, login to view]%28v=wps.630%[url removed, login to view]

$50 USD in 3 days
(24 Reviews)

Hello, I am having 7+ years of experience in, C# Development, I have gone through your details and ready to Start now. Please check my work links below - - - [url removed, login to view] | [url removed, login to view] More

$103 USD in 5 days
(2 Reviews)

I have been doing software development I have done this in one of my project previously. I would be interested in working with you. Please see my profile to know more about my technical skills. Thanks

$55 USD in 3 days
(2 Reviews)

I have more then 5 years of experience in Web and windows application development. I have expertise in ASP.Net c# Programming,MVC 4.0,Reports,WPF,WCF,DotNetNuke(dnn) Expert, Sql Server 2005/2008/2012,Html 5, CSS3, Java More

$222 USD in 30 days
(0 Reviews)