I thought the SQL Server 2005 Large Values out of Row would be a sp_tableoption config value similar to text in row - apparently not! It took a while to find out that this is hidden in sys.tables. The following query returns the value I was looking for:
SELECT [name] AS tablename, large_value_types_out_of_row FROM sys.tables
The PPS UK launch is happening on 16th October in London. Sign up here: http://www.microsoft.com/uk/office/ppslaunch/default.mspx
Lots of useful info appearing here http://sqlcat.com/Default.aspx. This is a great article on database mirroring log compression in Katmai http://sqlcat.com/technicalnotes/archive/2007/09/17/database-mirroring-log-compression-in-sql-server-2008-improves-throughput.aspx
This is a nice touch, the pre-canned VHD's are now available for pre-release versions of SQL Server 2008 CTP4 http://www.microsoft.com/downloads/details.aspx?FamilyID=6a39affa-db6e-48a9-82e4-4efd6705f4a6&DisplayLang=en and Windows Server 2008 Beta 3 http://www.microsoft.com/downloads/details.aspx?familyid=9AA65956-4A13-46A3-9711-82939A041792&displaylang=en. Note: the VHD download is split into approximately four compressed .rar files.