Hello hopefully someone will know this. When I try to import an sql file (corresponding to the Login control in chapter 4) to a host sql server 2005 database, the tool I am using is claiming that the sql file contains a syntax error

Error -2147217900
  Incorrect syntax near 'END'.


I admit I know nothing about sql syntax, but I saw these strange things in the syntax could they be errors? What concerns me is the apostrof following the END. Most 'END' don't have an apostrof but some do. Could this be an error?

-------- sample 1 ---------
CLOSE c1
    DEALLOCATE c1
END'

-------- sample 2 ---------
INSERT dbo.aspnet_Users (ApplicationId, UserId, UserName, LoweredUserName, IsAnonymous, LastActivityDate)
    VALUES (@ApplicationId, @UserId, @UserName, LOWER(@UserName), @IsUserAnonymous, @LastActivityDate)

    RETURN 0
END'

END

-------- sample 3 ---------
    RETURN @ErrorCode

END'
END

Well I got an explanation to this. Even though godaddy.com web page says "Database version 2005" it is actually SQL Server 2000 servicepack 4, according to the customer service individual I contacted. Usually customer service at godaddy would not know what SQL is, so I am still a little suspicious he is mistaking it for the windows version of the server (which is one reason I am asking questions here instead). But all I can do is take his word for it.

Well I guess I need to find out how to convert SQL 2005 .sql file into a SQL 2000 .sql file, if that is possible at all.

Well, you can equally easy use the Database Publishing Wizard to generate an SQL 2000 sql file instead. However, exactly the same thing happens.

Godaddy Database Manager does not like to import anything it seems.

Well I talked to godaddy customer support and I was informed that it is not SQL server 2000 service pack four they are using, it was actually SQL server 2005. However, it does not matter in any case, it does not work either way.

Well I think it is time that I stop talking to myself and end this thread.

Have you tried a simple SQL test script? E.g. one that creates a simple table? Or even easier, one that only inserts a single record in a table?

I worked with the Database Publishing Wizard once or twice and it has worked fine for me.

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.