sp_indexes_rowset causing an Access Violation

  • I have a SQL 2008 server (10.0.5890) showing regular Stack Dumps. I've not found a lot out there on this stored proc, but from what I can see it looks like this is called by ADO .Net applications when a table hasn't been fully qualified, or by Linked Servers.
    The dump file has this info:
    *   Exception Address = 0000000000ECF7C2 Module(sqlservr+000000000070F7C2)
    *   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION
    *   Access Violation occurred reading address 0000000000000000
    * Input Buffer 108 bytes -
    *    [ bdname ] .  1a 00 5b 00 6c 00 65 00 67 00 61 00 6c 00 5d 00 2e 00
    *  . s p _ i n d e x  2e 00 73 00 70 00 5f 00 69 00 6e 00 64 00 65 00 78 00
    *  e s _ r o w s e t  65 00 73 00 5f 00 72 00 6f 00 77 00 73 00 65 00 74 00
    *      ç      2  l g  00 00 00 00 e7 10 00 09 04 00 01 32 10 00 6c 00 67 00
    *  p a r a m c   ç    70 00 61 00 72 00 61 00 6d 00 63 00 00 00 e7 00 00 09
    *     2ÿÿ  ç      2ÿÿ 04 00 01 32 ff ff 00 00 e7 00 00 09 04 00 01 32 ff ff

    Has any one seen something like this and have any ideas what could be causing it? From what I can see the proc is pretty basic, returning the details on all the indexes on a given table.
    I can't see that it should be causing an issue.

    Further info is that the database is in SQL 2000 (80) Compatibility mode!
    Leo 

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

  • Can you share the dump file ?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply