Post reply

Need Login History

  • February 9, 2010 at 1:15 am

    #215399

    I need checking whether what they were doing in past 24 hrs or last few days activitiy. something happed in server, we need know what kind of activities and who did that.

    please help on this

  • February 9, 2010 at 6:32 am

    #1116072

    Do you have any auditing set up?

    Also check teh standard reports that is there. You can see schema changes and all that.

    -Roy

  • February 10, 2010 at 9:33 am

    #1116948

    Look up "default trace" in BOL.

    This server option is turned on by default. There's little documentation on when and what data it collects, however, you may be able to glean some information from the trace to point you in the right direction.

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

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