Unsupported property TextInRowSize set and is not supported when used as part of a data package

Error

[dbo].[TableName] has an unsupported property TextInRowSize set and is not supported when used as part of a data package.

Cause

TextInRowSize stores large data for older SQL Server types such as text and ntext. This is not supported in SQL Azure.
You can find all the tables having this problem by running this query:

select name, objectproperty(object_id,'tabletextinrowlimit') as TextInRowSize

from sys.tables

where objectproperty(object_id,'tabletextinrowlimit') <> 0

Fix

The column in question must be changed to use a SQL Azure type like nvarchar(max), but the TextInRowSize value must first be switched off. If the column has already been changed from ntext to nvarchar(max) then you must add a dummy column, switch off the value, then remove the dummy column.
To Remove the setting:

sp_tableoption N'[UserDefinedData]', 'text in row', 'OFF'

To Remove the setting if you get a 'Cannot switch to in row text in table'

ALTER TABLE TableName ADD [dummy] text;

EXECUTE sp_tableoption 'TableName', 'text in row', 'OFF';

ALTER TABLE TableName DROP COLUMN [dummy];

Part of the SQL Azure Compatibility Centre