Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

connection attributes Expand / Collapse
Author
Message
Posted Monday, April 14, 2008 8:35 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 4:12 AM
Points: 1,191, Visits: 697
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.
Post #484447
Posted Monday, April 14, 2008 10:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
dbcc useroptions
Post #484531
Posted Monday, April 14, 2008 12:59 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 4:12 AM
Points: 1,191, Visits: 697
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.
Post #484599
Posted Monday, April 14, 2008 1:24 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,732, Visits: 23,078
I see your dilema - I don't think there is a good way of doing what you want.
Post #484615
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse