InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 17:57:13 GMT20http://www.sqlservercentral.com/Forums/Topic484447-146-1.aspxI see your dilema - I don't think there is a good way of doing what you want.Mon, 14 Apr 2008 13:24:52 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic484447-146-1.aspxThanks 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.Mon, 14 Apr 2008 12:59:08 GMTJames_Bhttp://www.sqlservercentral.com/Forums/Topic484447-146-1.aspxdbcc useroptionsMon, 14 Apr 2008 10:43:41 GMTMichael Earl-395764http://www.sqlservercentral.com/Forums/Topic484447-146-1.aspxI 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.Mon, 14 Apr 2008 08:35:07 GMTJames_B