How do I find out if Large Values out of Row is enabled?

  • Article

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