dbcc useroptions and sessionproperty | SQL Server Performance Forums

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
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=’;)‘ />]<br /><br />