Importing .sql file into Server 2005...
Posted on 2008-06-25
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?