yoi55
asked on
Importing .sql file into Server 2005...
I have a .sql file that will create a new database. It was made for SQL 2000, but we are running SQL 2005. When I run the .sql file it completes, but gives some errors about join operators that do not work in 2005. I know that you can make a database's compatibility level SQL 2000 after it is created, but I need to set the compatibility level before I execute the script so that it finishes without errors. Can this be done?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The uncompressed file is over 7MB in size. It is attached.
SQL-File.zip
SQL-File.zip
ASKER
I need to get this resolved pretty quick. I can edit the file myself, but I cannot figure out exactly what needs to be changed. I have attached a code snippet...what do I change it make it compatible with SQL Server 2005 (ANSI)?
SELECT i.FLDREC_NUM,
i.FLDEMPLOYEE,
i.FLDNORMAL,
i.FLDRESULT,
i.FLDDATE,
E.FLDBDATE,
E.FLDSEX,
G.FLDM_OR_F
FROM inserted i,
EMPLOYEE E,
GENDER G
WHERE E.FLDREC_NUM = i.FLDEMPLOYEE AND
E.FLDSEX *= G.FLDCODE AND
i.FLDNORMAL > ' '
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER