My mistake, the SQL version is 2005 but I specified in the server_sql_details table that it is a 2000. I changed the value from 8 to 9 and it now works....thanks!