Results 1 to 3 of 3
  1. #1
    Join Date
    May 2013
    Posts
    6

    Smile Unanswered: Audit login trace failed

    Hello everyone,
    Given below is the Failed job report:

    XXXX Loading AuditLogin Trace failed
    XXXX Audit Logout Trace Load Job failed
    Error Number: 50000
    Error Severity: 16
    Error State: 1
    Error Message: Either rowcount is 0 or some other error occured

    It would be great if somebody helps me out with the remedy and also gives me a brief insight into audit login trace failures.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    Is this a SQL Agent job? If so, it does not look like one that normally ship with SQL Server.

  3. #3
    Join Date
    May 2013
    Posts
    6
    Yes this is a sql agent job.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •