How do I find out if Large Values out of Row is enabled?
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