Line 1: Incorrect syntax near 'XML'.

I just installed sql server 2000 and am trying to get the following statement to execute from query analyzer.  However I get the Incorrect syntax near 'XML'.
    SELECT 1 as Tag
           ,0 as Parent
           ,Null as [user!1!user]
    FOR XML EXPLICIT
maytrAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
Maybe the database is in compatibility mode 7 (sql server 7), because I tried your syntax and got no error...

CHeers
0
 
maytrAuthor Commented:
Guess something must have installed incorrectly, I reinstalled and all is good
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.