Hello everyone, Found a number of join forms using a particular column in the join criteria. This column did not look it was indexed on the base form (i.e. HPD:Help Desk), so thought let's create one. When I tried to do so I got a SQL error:
No se pudo crear índice no agrupado 'I1035_904003986_1' porque supera el máximo de 249 permitido por tabla o vista. (SQL Server 1910) (ARERR 552). Failure during SQL operation to the database : 904003986 (ARWARN 552). This simply means that the SQL server could not create the nonclustered index as it is beyond the maximum allowed. The form has 13 indexes. As a test I removed an existing non clustered index and create the new one and it works just fine, but of course I want to keep all the existing ones and be able to create the new one. I checked the table definition in the SQL Enterprise client by running sp_helpindex and got a list of some 250 entries. Now, I don't have a non customised version of this form nor do I have another environment to check if this is all created by the remedy server, hence the question, does anyone have all these indices defined on the Help Desk form in their ITSM 7.0 installation? I am using ARS 7.1 patch 4 / ITSM 7.3 / SQL server 2005. Here is part of the 250 entries. index_name,index_description,index_keys I1035_1000000019_1,nonclustered located on PRIMARY,C1000000019, C1000000018 I1035_1000000063_1,nonclustered located on PRIMARY,C1000000063, C1000000064, C1000000065 I1035_1000000079_1,nonclustered located on PRIMARY,C1000000079 I1035_1000000080_1,nonclustered located on PRIMARY,C1000000080 I1035_1000000161_1,nonclustered, unique located on PRIMARY,C1000000161 I1035_1000000427_1,nonclustered located on PRIMARY,C1000000427 I1035_1000000869_1,nonclustered located on PRIMARY,C1000000869 I1035_1000000875_1,nonclustered located on PRIMARY,C1000000875 I1035_179_1,nonclustered, unique located on PRIMARY,C179 I1035_200000003_1,nonclustered located on PRIMARY,C200000003, C200000004, C200000005 I1035_240001002_1,nonclustered located on PRIMARY,C240001002 I1035_4_1,nonclustered located on PRIMARY,C4 I1035_7_1,nonclustered located on PRIMARY,C7 missing_index_100016,nonclustered located on PRIMARY,C1000000079, C1000003009, C7 missing_index_100040,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000296, C1000000082, C1000000217 missing_index_100058,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000079, C1000000082, C1000000217 missing_index_100062,nonclustered located on PRIMARY,C1000000014, C1000000079, C1000000217, C1000000251, C1000000082 missing_index_100064,nonclustered located on PRIMARY,C1000000014, C1000000217, C1000000251, C1000000082 missing_index_100089,nonclustered located on PRIMARY,C1000000079, C7 . . . . missing_index_99846,nonclustered located on PRIMARY,C1000000099, C1000000251, C7 missing_index_99878,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000082 missing_index_99880,nonclustered located on PRIMARY,C1000000014, C1000000251, C1000000082, C1000000217 missing_index_99882,nonclustered located on PRIMARY,C1000000014, C1000000079, C1000000251, C1000000296, C1000000572, C1000000082, C1000000217 missing_index_99929,nonclustered located on PRIMARY,C7 PK__T1035__4032018A,clustered, unique, primary key located on PRIMARY,C1 Regards frex _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
