Carlo Romagnano (1/11/2011)
Koen (da-zero) (1/10/2011)
Good, but difficult question. I had to read quite some BOL pages to get this one right.And only 1 point?
I get it wrong, because I don't want waste my time to learn BOL for a deprecated option.
And what if your company or your client uses an older version of SQL Server (there are still some SQL 2000 or older out there. SQL Server 2005 is still common)? Doesn't it make sense to know some of the implications of such a setting?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP