I add a text field of size 5000 to an existing table using arcmap. All looks good. Publish the table within a service and the service reports it as:
NOTES ( type: esriFieldTypeString , alias: NOTE , editable: true , nullable: true , length: 1073741822 )
Looking at the table in arcmap the size is now showing as 1,073,741,822. Anyone else have this issue and know what I do to fix it? The service on the table does not work unless I remove that field.
Solved! Go to Solution.
Reading the link above I found out that the make size for a NVARCHAR field in my mssql database was 4000. MS's site said to deduct 2 from the length so it will not create as size max.
FNOTES ( type: esriFieldTypeString , alias: FNOTES , editable: true , nullable: true , length: 3998 )
Thanks for the help. The service is working.
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
I got that by running the command "select @@version".