Tsql function sql server 2012, DOT NET Programming

Assignment Help:

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')


Related Discussions:- Tsql function sql server 2012

Object pooling in .net, How object pooling in .NET is done COM+ reduces...

How object pooling in .NET is done COM+ reduces overhead by creating object from scratch. Thus  in COM+ when object is activated its activated from pool and when its deactivate

Add in bitcoin payment option in website, Add in bitcoin payment option in ...

Add in bitcoin payment option in website Project Description: Include bitcoin files to magento for payment options on website. It is just including the files to the magent

Different locks in sql server, What are the different locks in SQL SERVER? ...

What are the different locks in SQL SERVER? Depending on the transaction level there are six types of lock that can be acquired on data :- 1)Intent: The intent lock des

Explain repeater control, How can you provide an alternating color scheme i...

How can you provide an alternating color scheme in a Repeater control?  AlternatingItemTemplate Like the ItemTemplate element, but rendered for each other row (alternating item

Explain the concept of destructor, Explain the concept of destructor? A...

Explain the concept of destructor? A destructor is a special method for a class and is requested automatically when an object is finally destroyed. The name of the destructor i

Explain ado.net in brief, Explain ADO.NET in brief. ADO.NET is a very s...

Explain ADO.NET in brief. ADO.NET is a very significant feature of .NET Framework, which is used to work with data that is stored in structured data sources, like databases and

XML, Write a XML with database with book details (BOOK ID, Title, Author, s...

Write a XML with database with book details (BOOK ID, Title, Author, subject, published Year, language, vendor, price)

Acid fundamental and transactions in sql server, What is ACID fundamental? ...

What is ACID fundamental? What are transactions in SQL SERVER? The transaction is a sequence of operations performed as a single logical unit of work..The logical unit of work

What is the role of the jit compiler in .net framework, What is the role of...

What is the role of the JIT compiler in .NET Framework? The JIT compiler is an significant element of CLR, which loads MSIL on target machines for execution. The MSIL is stored

Simple Harmonic Motion, How can you make a simple harmonic motion in visual...

How can you make a simple harmonic motion in visual basic 2010 where you will ask an input to the user and your output will be a moving pendulum and a graph. Also the displacement

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd