SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


connection attributes


connection attributes

Author
Message
James_B
James_B
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1355 Visits: 738
I have tried searching and I dont seem to be able to find a way of getting this info easily.

within my organisation I need to start checking the connection attributes used by developers on our SQL servers. Is there a simple way of viewing the connection settings of each process regardless of how it is set and see the connection type. E.g Some applications will use ADO, ADO.net, OLEDB or ODBC connections and they may set connections in various ways including using t-sql commands like set isolation level or calling SQLSetConnectAttr. I would also like to know what type of .Net data object (e.g. reader, adapter) that is being used but not sure if that is even possible.

Ideally I would like a result set with the spid, connection type and a series of columns representing the different connection attributes containing the current value for that connection. We have both 2000 and 2005 servers.
Michael Earl-395764
Michael Earl-395764
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13479 Visits: 23078
dbcc useroptions
James_B
James_B
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1355 Visits: 738
Thanks Michael. dbcc useroptions is great for my connection but I cant seem to get it to work for other connections that I don't have control of but am trying to administer/monitor. I don't really want go down the line of sp_bindsession.
Michael Earl-395764
Michael Earl-395764
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13479 Visits: 23078
I see your dilema - I don't think there is a good way of doing what you want.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search