I'v seen this, but thought I worked around it. I've been meaning to
install SQL 7 b3 here, but haven't had a chance yet. I'll do some tests
and see what I can come up with to correct it.
> **************************
> CREATE TABLE ServerAccess
> (
> ServerID int NOT NULL ,
> Port int NULL FOREIGN KEY (ServerID, Port) REFERENCES
> ServerPorts(ServerID, Port) ,
> AccountType varchar(15) NOT NULL REFERENCES
> AccountTypes(AccountType) CONSTRAINT pk_ServerAccess PRIMARY KEY (ServerID,
> Port, AccountType),
> StartTime int NULL DEFAULT (0) ,
> StopTime int NULL DEFAULT (0) ,
> MaxSessionLength int NULL DEFAULT (0)
> )
> GO
> **************************
> returns
> **************************
> Msg 8140, Level 16, State 0
> More than one key specified in column level FOREIGN KEY constraint, table
> 'ServerAccess2'.
> Msg 8111, Level 16, State 1
> Cannot define PRIMARY KEY constraint on nullable column in table
> 'ServerAccess2'.
> Msg 1750, Level 16, State 0
> Could not create constraint. See previous errors.
> **************************
> Everything else seem to work fine, I'll continue testing with Radius /
> Emerald 2.5 and keep you posted.
>
> Mit freundlichem Gruss,
>
> Peter A. Sang
> SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
> T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
> * Microsoft Solution Provider - Internet/Intranet Specialist *
-- Dale E. Reed Jr. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com