sp_indexes_rowset causing an Access Violation

• Leo.Miller

  SSChampion

  Points: 13051

  More actions

  March 8, 2017 at 7:18 pm

  #335611

  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.

• Bilal Ayub

  SSC-Addicted

  Points: 411

  More actions

  March 8, 2017 at 8:18 pm

  #1932446

  Can you share the dump file ?