I Opened a new Sql server management studio and tried the create statement without any set options. Query works fine.

can you xplain in detail?