Normally, when you try to create Non-Clustered Index on MSSQL Server Platform, SE14 gives errors
Read more
Add comment (0)
Hits: 1461
MSSQL
Create Non-Clustered Index on MSSQL
MSSQL 2005 Autogrowth Option
If you want to set autogrowth option for a datafile on MSSQL 2005, you can simply use the following commands:
Creating Non-Clustered Index on MSSQL
If you want to create non-clustered indices on a MSSQL Database, normally you may get error as follow:
Request: Create Index LIPS-Z01 (R3DEV/03.01.06/06:32)
Process: msisrv03_0
sql:
CREATE
INDEX [LIPS~Z01] ON [LIPS]
( [VGBEL] ,
[VGPOS] )
Cannot create more than 249 nonclustered indices or column statistics on one table.
DDL time(___1): ........56 milliseconds
The SQL statement was not executed
Index could not be created completely in the database
Index LIPS-Z01 could not be created
Request for LIPS could not be executed