Josh
-----Original Message-----
From: Dale E. Reed Jr. <daler@iea-software.com>
To: emerald@iea-software.com <emerald@iea-software.com>
Date: Friday, July 09, 1999 3:19 AM
Subject: Re: [Emerald] can't re-port or create the ServerAccess table
>Josh Hillman wrote:
>>
>> I tried to re-port my Maxes in Emerald Admin under the Servers tab and I
got
>> the following message:
>> Invalid object name: ServerAccess
>>
>> So, I then realized that our database is missing that table. I then
tried
>> to run the following to create it:
>>
>> /****** Object: Table dbo.ServerAccess Script Date: 11/22/95 9:30:47
PM
>> ******/
>> CREATE TABLE ServerAccess (
>> ServerID int NOT NULL ,
>> Port int NULL DEFAULT NULL ,
>> AccountType varchar (15) NOT NULL ,
>> StartTime int NULL DEFAULT (0),
>> StopTime int NULL DEFAULT (0),
>> MaxSessionLength int NULL DEFAULT (0),
>> FOREIGN KEY (AccountType) REFERENCES AccountTypes (AccountType),
>> FOREIGN KEY (ServerID) REFERENCES ServerPorts (ServerID)
>
>This should be Servers not ServerPorts
>
>> )
>> GO
>>
>> I got the following error message:
>> Msg 1776, Level 16, State 0
>> There are no primary or candidate keys in the referenced table
'ServerPorts'
>> that match the referencing column list in the foreign key
>> 'FK__ServerAcc__Serve__3E723F9C'.
>> Msg 1750, Level 16, State 0
>> Unable to create constraint. See previous errors.
>>
>> What do I do?
>>
>> Emerald 2.5.278, Emerald Admin 2.5.288, SQL 6.5 SP5a
>
>--
>
>
>Dale E. Reed Jr. Emerald and RadiusNT
>__________________________________________
>IEA Software, Inc. www.iea-software.com
>
>For more information about this list (including removal) go to:
>http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart