SQL Server Performance Forum – Threads Archive
dbcc useroptions and sessionproperty
Are there any difference between the values returned by dbcc useroptions and sessionproperty?No change in the results between the 2 statements. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
Satya,<br /><br />Thank you for the reply. When there are multiple system functions for the same information, I always wonder there are any difference. I guess the only difference is that sessionproperty is a SQL Server 2000 function.[<img src=’/community/emoticons/emotion-5.gif’ alt=’

]]>