Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    2

    Unanswered: Run-time error '-2147467259(80001005)'

    Hi.
    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.

    thanks...

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    your dba should do this for you.
    sp_configure 'number of auxiliary scan descriptors',14
    go

  3. #3
    Join Date
    Apr 2006
    Posts
    2

    Thanks

    It really helped, thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •