Re: DNIS Number Field too small

Dale Reed ( )
Fri, 19 Jun 1998 01:04:33 -0700

J Dyer wrote:
> The DNISNumbers are currently set as ten characters this is too small, the
> minimum for UK national numbers is 11,
> (The NAS is returning the Dialup number as the DNIS is this correct?)
> With the database live, SQL Ent. Manager does not allow me to change this
> size, Is a script needed or the database running in single user mode ?

SQL Server doesn't allow you to change the size of an existing field.
You have to re-create the table. 11 is pretty big. Usually DNIS
only includes a portion of the number and not the whole number itself.
I'll change the DB layout to be 12. DNIS is the number the user dialed
and Caller-ID is the number of the calling user.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |