By default, SQLSERVER creates primary keys as clustered. Whe must set "clustered" to "OFF" to update over 8000 bytes in text field.
Right click on your table Select design mode Highlight the primary key(s) Right click on one of them Select "index/key" Set the parameter "create as clustered" to "off" SAVE THE TABLE Thank you All --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
