Hi,

 I have successfully installed umbraco 4.5.2 on a windows xp machine using sqlserver 2008. I've now been asked to install it on the same xp machine but pointing to a sql 2005 server. Things go smoothly and the db is created, but I get the error "incorrect syntax near (" from the db script. When I go look, the db looks fine except that the table cmsPreviewXML is missing. I can use Umbraco, but the publish/preview throws an error because the table is missing.

 So I tried scripting out the table from my 2008 database and when I run it on the 2005 server, I get that same message "incorrect syntax near (" but as far as I can tell, the syntax is fine.

I also tried installing the 4.5.1 umbraco package but got the same problem.

 I tried creating the table manually but I don't know enough about sql server to know how to create the constraints by hand.

Any suggestions?

thank you.