Symptom
You try to create a database index in transaction SE14 and it fails with:
CREATE
INDEX [<index_name] ON [table_name]
( <column_list> )
WITH FILLFACTOR = 90
WITH ( ONLINE=ON )
ON [PRIMARY]
Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon.
[...]
The SQL statement was not executed
Statements for Table <table_name> could not be executed
Request for <table_name> could not be executed
Index could not be created completely in the database
Index <index_name> could not be created
Request for <table_name> could not be executed
Read more...
Environment
- Microsoft SQL Server 2005 and Higher
- SAP NetWeaver based systems running on Windows and SQL Server
Keywords
SE14,create index,Incorrect syntax near the keyword 'with' , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.