Difference between revisions of "Increasing the Maximum Size of the Analyst E-Mail Address Field"

@@ Line 1: / Line 1: @@
-{{Template:Basic Cover
-|title=Increasing the Maximum Size of the Analyst E-Mail Address Field
-|type=FAQ
-|htl=Y
-}}
-{{Template:Basic Status
-|status=Published
-|version=1.0
-|authors=HTL QA
-|applicableto=Supportworks ESP up to Version 7.4.1 (then in on-line help)
-}}
-== Increasing the Maximum Size of the Analyst E-Mail Address Field ==
-By default, the maximum number of characters you can have in an analyst's e-mail address, as stored in the ''swanalysts''  table, is 32. If you attempt to enter more than this in the relevant  field of the Analyst Properties form, you will find, on reading back the  record, that the address has been truncated.
-To extend the  maximum size, run the Interactive SQL utility by selecting Start >  All Programs > Hornbill Core Services > Interactive SQL and enter  the following SQL command:
-<pre>use sw_systemdb
-alter table swanalysts modify contactE varchar (n);</pre>
-where <code>n</code> is the required maximum number of characters.

Revision as of 09:16, 10 April 2015