[Webinar] Learn how to a build a cloud-first strategyRegister Now


SP-0042 Error

Posted on 2011-04-18
Medium Priority
Last Modified: 2012-05-11
I am trying execute SQL file using command @c:\create.sql and I get the following ERROR.

SP2-0042: unknown command "ÿþC" - rest of line ignored.

In some of the forums, it was suggested to check the SQL file for errors but there are absolutely no errors. At least one command should execute. I have attached create.sql file.

In another forum, it was suggested to check glogin.sql but could not trace anything. glogin.sql
also attached

I thought problem in my PC but other PC also gives same error.

Question by:GRChandrashekar
  • 4
  • 2
LVL 14

Expert Comment

ID: 35421610

Author Comment

ID: 35421623
Well I did try this but no luck
LVL 14

Accepted Solution

ajexpert earned 2000 total points
ID: 35421648
Your file does contains special characters.  Copying and saving from notepad should resolve the issue

If not, try to break the scripts into various sub scripts and execute, this way you will find the section which containts erroneous data.
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.


Author Comment

ID: 35421653
No. I deleted entire file except the first crate sequence command. Still the same error
LVL 14

Expert Comment

ID: 35421661
I know this is not a solution, but can you try executing it from any other tool like SQL Developer, PL/SQL Developer or TOAD?
LVL 14

Expert Comment

ID: 35425557
thanks for accepting my comment.

Can you please let us know how did you remove the special character?

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses
Course of the Month20 days, 12 hours left to enroll

865 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question