Thread: Incorrect syntax near

I am getting this error when I ran the SQL script on a new installation of the store database.

Msg 170, Level 15, State 1, Procedure aspdnsf_GetNews, Line 9
Line 9: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetFeaturedProducts, Line 18
Line 18: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetRecentlyViewedProducts, Line 27
Line 27: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetRecentlyViewedProducts, Line 31
Line 31: Incorrect syntax near 'i'.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetCustomersRelatedProducts, Line 40
Line 40: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetCustomersRelatedProducts, Line 103
Line 103: Incorrect syntax near 'prd'.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetCustomersRelatedProducts, Line 108
Line 108: Incorrect syntax near '('.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetCustomersRelatedProducts, Line 118
Line 118: Incorrect syntax near 'tp'.
Msg 170, Level 15, State 1, Procedure aspdnsf_GetCustomersAlsoBoughtProducts, Line 24
Line 24: Incorrect syntax near '('.
Msg 156, Level 15, State 1, Procedure aspdnsf_GetCustomersAlsoBoughtProducts, Line 53
Incorrect syntax near the keyword 'ORDER'.


And anyone tell me what I am doing wrong?

Are you trying to install on SQL 2000? You need to be using SQL 2005 or 2008. You might also want to have a look at this knowledgebase article.