Skip to content Skip to sidebar Skip to footer
Home / Sql / Ssms

Microsoft Sql Service Management Studio 2005 'script Xxx As Create To' Problem

Post a Comment
When using the 'Script Index as CREATE To' to duplicate an index from one table to another table I am not able to run the script. Without editing the generated code I get an error.

Solution 1:

What's the compatibility mode or server level set to for the destination database? Is it SQL 2000 (or compatibility mode 80)? If so, then the WITH option will not run; the syntax generated by the SQL 2005 Mgmt Studio is 2005 compliant (even if you issue it against a SQL 2000 server or 2000-compliant database).


Post a Comment for "Microsoft Sql Service Management Studio 2005 'script Xxx As Create To' Problem"