Re: [Emerald] Truncating Domain Name
Dale E. Reed Jr. ( (no email) )
Mon, 05 Jul 1999 23:37:00 -0700
TL Roberson wrote:
>
> We registered a domain name for a customer "propertiesandprospects.com".
> When I attempted to insert this along with other domains SQL Query Analyzer
> returned
>
> Server: Msg 8152, Level 16, State 9, Line 1
> String or binary data would be truncated.
> The statement has been terminated.
>
> I noticed the Domain.Domain and Domain.MailDomain column properties are set
> at 25. When I changed it and attempted to save it, the alert "the following
> tables will be saved to your database 'Domains Groups (not on the diagram)'.
> Can we change this without affecting Emerald, and how?
You only need to change the length of Domain.MailDomain. If you have
SQL 7, you can change the size in Enterprise Manager.
> Secondly, can we add two columns to the MasterAccounts table for zip+4 and
> barcode data?
I would prefer you create a new table and link the two with the
CustomerID.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com
For more information about this list (including removal) go to:http://www.iea-software.com/support/maillists/liststart