I tried running that command and received the following error:
Msg 547, Level 16, State 2
INSERT statement conflicted with COLUMN FOREIGN KEY constraint
'FK__Groups__DomainID__103673A0'. The conflict occurred in database
'Emerald25', table 'Domains', column 'DomainID'
Command has been aborted.
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Monday, May 10, 1999 4:23 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Billing Group global
Christian Lawrence wrote:
>
> This is in the emerald admin. All of the groups transferred over fine.
Ok. There is a difference between how the 2.5 admin and the 2.2
admin used that. Go into isql_w and do a:
select * From Groups
and see what it returns. You should have a global entry. It should
have been added by updttabs.sql for you, if you don't have it. If you
don't, run this:
SET IDENTITY_INSERT Groups ON
EXEC("
INSERT
Groups(GroupID,DomainID,GroupName,Description,SortOrder,GlobalOptions)
VALUES(-1, 1, 'Global', 'All Groups',0, 1)
")
SET IDENTITY_INSERT Groups OFF
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com