How can we help you today? How can we help you today?

Long Running Query - ID's wrong Process but right SQL

The query in question runs as User sa and is a SQLAgent Job - it has nothing at all to do with what SQL Response identifies as "Microsoft Content Management Server". The same query is correctly pulled up under another, earlier, Incident of the same type on the same DB in the same Server... Crossed wires?
PDinCA
0

Comments

7 comments

Sort by
  • Nigel Morse
    Hi,
    So are you saying the SQL reported is the same as the job one, but the other information is wrong?

    Could you tell me what version of SQL server this incident is occuring on?
    Nigel Morse
    0
  • PDinCA
    SS2K Build 8.00.2039

    That's exactly what I'm saying...
    PDinCA
    0
  • Nigel Morse
    Thanks - any chance you could send screen shots of both the correct and incorrect ones if you still have them available?
    Nigel Morse
    0
  • PDinCA
    This hasn't happened again yet (happened twice last week on separate days), will post via email as soon as it recurrs.
    PDinCA
    0
  • Nigel Morse
    Thanks. Could you let me know which version of SQL Server this is happening on please?
    Nigel Morse
    0
  • PDinCA
    PDinCA wrote:
    SS2K Build 8.00.2039
    PDinCA
    0
  • Nigel Morse
    PDinCA wrote:
    PDinCA wrote:
    SS2K Build 8.00.2039

    :oops: it was early morning before my coffee - sorry!
    Nigel Morse
    0

Add comment

Please sign in to leave a comment.