Create Index Errors (1900s)

1901      16           Column '%.*s' -- Can't create index on a column of BIT data type.
1902      16           Cannot create more than one clustered index on table '%.*s'.  Drop the existing clustered index '%.*s' before creating another
1903      16           %d is the maximum allowable size of an index.  Composite index specified is %d bytes.
1904      16           Cannot specify more than %d column names for index key list. %d specified.
1905      21           Could not find 'zero' row for index '%.*s' the table in sysindexes.
1906      11           Cannot create an index on table '%.*s', because this table does not exist in database '%S_DBID'.
1907      10           Create index on non-empty table not supported yet
1908      16           Too many parameters -- symbol table overflow.
1909      16           Can't use duplicate column names in index key list. Column name '%.*s' listed more than once.
1910      16           Cannot create more than %d indexes on one table.
1913      16           There is already an index on table '%.*s' named '%.*s'
1914      16           Cannot create index on object '%.*s' because it is not a user table.
1915      14           Only the owner of table '%.*s' or a user with System Administrator (SA) role can create an index on it.
1916      16           CREATE INDEX options %s and %s are mutually exclusive.
1918      10           Non-clustered index (index id = %d) is being rebuilt.
1919      16           Column '%.*s' -- Can't create index on a column of TEXT, IMAGE or UNITEXT data type.
1920      16           Column '%.*s' is part of a primary key constraint and cannot be null.
1921      16           An index with the same columns in the same order already exists on the table '%.*s'.
1922      16           An unknown index creation error occurred: %d.
1923      16           A table cannot have more than one primary key, attempt to define a second primary key failed on table '%.*s'.
1924      16           You cannot create an index on the sysaudits table.
1927      16           Create Index failed because user curwrite level is not equal to the level of table '%.*s'.
1928      16           Cannot create clustered index '%.*s' on '%.*s' which has %d partitions because the maximum number of partitions allowed on a table with clustered index is %d.
1929      20           Failed to reserve/initialize allocation hints space in index '%.*s' on table '%.*s' partition ID %ld.
1930      16           Cannot specify more than %d column names for index key list. %d specified. Check sp_dboption for nonunique index option, it has added an extra key for indentity coulumn.
1931      16           You cannot re-create the same non-clustered index (ID %d) for object ID %ld in database '%.*s' because you dropped it twice in a single transaction. Transaction rolled back.
1932      16           You cannot re-create the same clustered index for object ID %ld in database '%.*s' more than once in a single transaction. Transaction rolled back.
1933      12           The object `%.*s' is not a partitioned table. UPDATE PARTITION STATISTICS can only be run on partitioned tables.
1934      16           Invalid partition number %d. Valid partition number is a positive integer.
1936      10           Warning: Clustered index '%.*s' has been created on the empty partitioned table '%.*s'. All insertions will be unevenly distributed.
                             To balance the data distribution in all the partitions, re-create the clustered index after loading the data.
1937      10           Warning: Clustered index '%.*s' has been created on the partitioned table '%.*s' with %d partitions using the segment %d with %d devices.
                             For complete I/O parallelism, each partition should be on a separate device.
1938      16           Cannot create index or unique constraint because cursor '%.*s' is still open. Close the cursor(s) before creating index or constraint.
1939      16           Cannot create a clustered index with sorted_data option on the 11.0 partitioned table '%.*s'. This option isn't allowed. To create the index do not use this option.
1940      16           Cannot create clustered index on table '%.*s' because there are one or more isolation level 0 scans, or REORG command, active on the table.
1941      10           Warning: Clustered index '%.*s' has been created with ignore_dup_row on table '%.*s', which uses data-only locking. ignore_dup_row cannot be 
                             enforced for subsequent insertions and updates.
1942      16           You cannot drop and re-create the same clustered index with sorted data for object ID %ld in database '%.*s' in a single transaction. Transaction rolled back.
1944      16           The clustered index cannot be created on a partitioned table using serial sort. The CONSUMER value specified in the CREATE INDEX command must be greater than 1.
1945      16           Cannot create unique index '%.*s' on table '%.*s' as a local index. The table partition condition and the specified index keys make it impossible to
                              enforce index uniqueness across partitions with a local index.
1946      16           The table partition condition make it impossible to check for duplicate rows across partitions. As a result, ignore_dup_row or allow_dup_row option for
                              index '%.*s' on table '%.*s' can be enforced on rows in each partition, but not across partitions.
1947      16           CREATE NONCLUSTERED INDEX failed because object ID %ld in database '%.*s' has more than %d indexes.
                             When 'ddl in tran' is on, metadata for dropped indexes is cleaned up after the transaction has committed.
1948      16           Clustered function-based index is not supported.
1949      16           Cannot create local index with more partitions (%d) than the number of table partitions (%d).
1950      16           Partitioned global index currently not supported.
1951      16           Cannot create a function-based index with %.*s option. This option is not allowed.
1952      16           Cannot create index on encrypted column '%.*s', due to an initialization vector, or random padding.
1953      16           Cannot create global clustered/placement index on Round Robin table with more than 255 partitions. Please create local clustered/placement index instead.
1954      16           Cannot create index on '%.*s' which has suspect partitions. This table is only available for read-only purposes until the REORG REBUILD or
                             Repartition (ALTER TABLE PARTITION BY) command has been run on the indicated table to repair the partitions.
1955      0             Internal coding error. An error occurred when attempting to create an index for replication. Please contact SAP Technical Support.
1956      10           Creating unique local index '%.*s' on partitioned table '%.*s' does not guarantee the uniqueness of an index key value across partitions.
1957      16           A create index DDL cluster notification error has happened - Create Index DDL operation on table '%.*s' is rolled back.
1958      20           %s %s on '%.*s' did not apply the log record %S_RID in database '%.*s' due to one or more preceding errors. Transaction has been rolled back.
1959      0             %s %s on '%.*s' cannot extract the log record %S_RID associated with CLR %S_RID in database '%.*s'. Transaction has been rolled back. 
                             Please contact SAP Technical Support for assistance.
1960      20           Cannot get the consolidated state of the descriptor associated with table '%.*s' in database '%.*s'. The command has been aborted.
1961      16           Local index '%.*s' not created, because data partition '%.*s' in table '%.*s' does not exist in database '%.*s'. Verify the data partition name.
1962      20           %s %s on '%.*s' cannot apply the CLR %S_RID in database '%.*s' as the correct row version cannnot be determined.
                             Transaction has been rolled back. Please retry the command.
1963      16           You cannot create an Online index with '%.*s' option.
1964      16           You cannot create an Online index when '%.*s' option is ON.
1965      10           Create index with hash-based stats is not supported on proxy table.
1966      10           Create index with hash-based stats on LOCAL index is not supported in parallel mode.
1967      10           Create index hash-based stats on column '%.*s' (column id = %d) are partially completed or missing.
1968      10           Warning: '%s' will be performed in offline mode because object '%.*s' does not have any physical storage.
1969      10           Create clustered index with hash-based stats on round-robin table partition is not supported in parallel mode.
1970      10           Create Index %.*s.
1971      10           Compressed index can not be created on encrypted columns, the index will be created as normal index.
1972      10           Index '%.*s' can not be create as compressed, it will be created as normal index.
1973      16           Create index with option '%s' is not supported on %s table.                                                                                                                                                                                                                                                                                                                                                                                                    
  1974      16           Create index with '%s' is not supported in %s database.                                                                                                                                                                                                                                                                                                                                                                                                        
  1975      16           Index partition of index '%.*s' for data partition '%.*s' of table '%.*s' has existed.                                                                                                                                                                                                                                                                                                                                                                         
  1976      16           Create partial index only supports to create index partition for one data partition.                                                                                                                                                                                                                                                                                                                                                                           
  1977      16           Create partial index fails because current CREATE INDEX has different index keys or options with others. Details: %s.                                                                                                                                                                                                                                                                                                                                          
  1978      16           Command '%s' can't be performed for %s '%.*s' if any partial index exists for it. Please retry after dropping the partial index or creating index partitions
                               on all data partitions for partial index. sp_helpindex can report partial indexes for it.                                                                                                                                                                                                         
  1979      16           Create index '%.*s' on table '%.*s' failed, because CREATE CLUSTERED INDEX WITH DEFER_RECOVERY is not supported.
                               Either retry without the WITH DEFER_RECOVERY clause or create a non-clustered index instead.                                                                                                                                                                                                                                                  
  1980      10           Warning: Index '%.*s' on table '%.*s' with deferred recovery option has not been recreated or dropped at ONLINE DATABASE time.                                                                                                                                                                                                                                                                                                                                 
  1981      10           Warning: Deferred recovery indices created with either the AUTO or the NONE option in database '%.*s' could not be recreated or dropped during ONLINE DATABASE time.                                                                                                                                                                                                                                                                                           
  1982      10           index id = %d could not be restored for object '%.*s' in dbid %d.                                                                                                                                                                                                                                                                                                                                                                                              
  1983      10           Warning: Deferred recovery indices in database '%.*s' could not be recreated or dropped or listed during ONLINE DATABASE time, because the database is not writable.                                                                                                                                                                                                                                                                                           
  1984      10           Index '%.*s' can not be created as latch free, it will be created without latch free functionality.                                                                                                                                                                                                                                                                                                                                                            
  1985      10           Latch free index can not be created on encrypted columns, it will be created without latch free functionality.                                                                                                                                                                                                                                                                                                                                                 
  1986      10           Index '%.*s' on table '%.*s' has been created with the database default of WITH DEFER_RECOVERY = %s.                                                                                                                                                                                                                                                                                                                                                           
  1987      10           %s index '%.*s' on table '%.*s' has not been created with the database default of WITH DEFER_RECOVERY = %s.                                                                                                                                                                                                                                                                                                                                                    
  1988      16           You cannot create an index with '%s' option on table '%.*s' enabled with '%s' when there are rows cached for it. Please retry without this option.                                                                                                                                                                                                                                                                                                             
  1989      10           Warning: %s clause is not specified, value %u will be used as the bucket count of hash table.                                                                                                                                                                                                                                                                                                                                                                  
  1990      16           The %s clause must be specified when a value is specified for the %s clause.                                                                                                                                                                                                                                                                                                                                                                                   
  1992      16           The clustered/placement index '%s' cannot be created on a round-robin partitioned table '%.*s' using serial sort.
                               The database option 'enforce dump tran sequence' prevents creating the index using parallel sort.