G'day people,

I have a sql script file this file supposedly should create a database. Unfortunately when I run this script (osql -E -S PENTIUM-666\VSdotNET -d UniversityDB -i DBuni.sql), I get errors.

This is the first error:
"Msg 547, Level 16, State 1, Server PENTIUM-666\VSDOTNET, Line 1
ALTER TABLE statement conflicted with COLUMN FOREIGN KEY SAME TABLE constraint
'SupervisorFK'. The conflict occurred in database 'UniDB', table 'Faculty',
column 'FacSSN'."

This is the second error I get:
"Msg 8115, Level 16, State 8, Server PENTIUM-666\VSDOTNET, Line 1
Arithmetic overflow error converting numeric to data type numeric.
The statement has been terminated."

------------------------------------------------------------------------------------

Here is my Alter statement:
"ALTER TABLE Faculty ADD
CONSTRAINT SupervisorFK FOREIGN KEY(FacSupervisor) REFERENCES Faculty
GO"

Here is the Faculty table declaration:
create table Faculty
(
FacSSN char(11) not null,
FacFirstName varchar(30) NOT NULL,
FacLastName varchar(30) not null,
FacCity varchar(30) not null,
FacState char(2) not null,
FacRank char(4),
FacHireDate datetime,
FacSalary decimal(10,2),
FacSupervisor char(11),
FacDept char(6),
FacZipCode char(10) not null,
CONSTRAINT FacultyPK PRIMARY KEY (FacSSN));

And here is the data that is supposed to be entered in Faculty table by the script:
INSERT INTO Faculty values
('098765432','LEONARD','VINCE','SEATTLE','WA','ASS T',35000.00,Null,'01-Apr-1990','MS','981119921');
insert into Faculty values('543210987','VICTORIA','EMMANUEL','BOTHELL' ,'WA','PROF',120000.0,NULL,'01-Apr-1991','MS','980112242');
insert into Faculty
VALUES('654321098','LEONARD','FIBON','SEATTLE','WA ','ASST',70000,NULL,'01-apr-1989','MS','981210094');
insert into Faculty
VALUES('765432109','NICKI','MACON','BELLEVUE','WA' ,'PROF',65000,NULL,'01-apr-1994','FIN','980159945');
insert into Faculty VALUES('876543210','CRISTOPHER','COLAN','SEATTLE', 'WA','ASST',40000.00,'654321098','01-Apr-1994','MS','981141332');
insert into Faculty
VALUES('987654321','JULIA','MILLS','SEATTLE','WA', 'ASST',75000,'765432109','01-Apr-1995','FIN','981149954');

------------------------------------------------------------------------------------

In the first error, what is the cause??? What should I do???

In the seocnd error is FacSalary causing problems or FacHireDate??? What should I do to solve the problem???

Thanks in advance!