View Customer Account Character Limits in the Database

Prior to importing customer accounts, make sure your data does not exceed the database character limits. Follow these steps to find the character limits for your database.

  1. Log in to Microsoft SQL Server as an administrator.
  2. In the panel on the left, expand Databases and then expand your database.
  3. Click Tables.

  1. In the list of tables in the main panel, scroll down to the CustomerAcct table.
  2. Right-click the CustomerAcct table and select Design.

  1. The list that opens shows the fields in the CustomerAcct table and the lengths for each field.