----- Original Message -----
From: Dale E. Reed Jr. <email@example.com>
Sent: Wednesday, November 03, 1999 6:34 PM
Subject: Re: [Emerald] Creating New Service
> Todd Coward wrote:
> > We're having a problem creating a new service in Emerald Admin.
> > error message as follows:
> > SQL Server Error: 515 Cannot Insert the value NULL into column
> > table 'Emerald25.dbo Account Types,' column does not allow nulls. INSERT
> > FAILS. State = 2, severity = 16
> > OK, so I then created a tax item of 6%. But I still get the same error,
> > matter whether I leave the taxable field at "none" or at "6%".
> > What's up?
> I think that Emerald 2.2 schema had a taxable field on the AccountTypes
> table, when it should not have. Just go into Emterprise Manager, drill
> down to the AccountTypes table, and add a default value to the taxable
> column, value 0, and save the changes. Then you should be fine.
> Dale E. Reed Jr. Emerald and RadiusNT
> IEA Software, Inc. www.iea-software.com
> For more information about this list (including removal) go to:
For more information about this list (including removal) go to: