Is there a log of activity as compared to the Tran log?

From: Stephen Russell (srussell_at_transactiongraphics.com)
Date: 09/23/05

  • Next message: Noone: "Re: MS Access linked tables SQL Server" 
    Date: Fri, 23 Sep 2005 08:30:52 -0500

    I am trying to identify if I have unwanted guests gaining access to my
    system or it's a run away query by a user on my network. I am thinking of
    recording SPIDs as one way.

    Via Spotlight I can see that I'm having beyond normal usage. Granted I have
    a new PHB who likes to run queries off his laptop to show off to other
    managers. Real scary when he has a little understanding of the data.

    The box running Spotlight is WAY under powered, but can it keep that logging
    data instead of the server itself?
     

  • Next message: Noone: "Re: MS Access linked tables SQL Server"