Products

Solutions

Learn More

Partners

Community

Blog

About

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

Return to previous page

  • 4/7/2015
  • 1309 Views

Comments

1309 Views

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

Last updated 3 years ago

Comments

Common

(Enter the content of this article below)

Advanced

 

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
Contents
No sections defined
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW
DNN Launch Webinar
REGISTER NOW