What kind of Error is this- Stack OverFlow

• The_SQL_DBA

  SSChampion

  Points: 10494

  More actions

  September 11, 2008 at 12:55 pm

  #125458

  I saw these errors today in my error log. What does this refer to. The ActivityIdCnt field has a Clustered Index defined on it and this table exists across 82 DB's on this server. The SPID is not active right now. I cannot monitor the Read/Write Counters right now bcos there are many application for each of the DB's running. Trying to catch the SPID if the error occurs again and will try to locate the DB against which this is run. Any one knows what is this.

  I feel the query is unable to return the number of ID's that are specified here but I want to locate who is doing this.

  sp_who2, sp_who or select * from sysprocesses doesnt give anything because the errors have stopped now. But still I want to know who did this, how can I?

  Thanks in Advance!!!

  See error logs for detail

  The_SQL_DBA
  MCTS

  "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  September 12, 2008 at 4:07 am

  #870844

  Since you're errorlog is from a SQL 2000 server it would help if you post it in the correct forum the next time.

  Check this article for more info about your problem and maybe upgrading to SP4 might help as well.

  [font="Verdana"]Markus Bohse[/font]