I'm currently developing an operational tracking system for my job with which our client can monitor the activities of his employees. Now I used a very big select query and it was working fine all of a sudden I get the error:
Run-time error '-2147467259(80001005)'
[Merant][ODBC Sybase ASE driver][SQL Seerver} This query requires 14 auxiliary scan descriptors, but currently there are only 6 auxiliary scan descriptors available. either raise the value of the 'number of auxiliary scan descriptors' configuration parameters
How can I raise this value or if this is not the answer how can I fix this.