Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696

    Unanswered: [SQLSTATE 01000] via Agent Job, but not Query Analyzer

    I run a sproc through query analyzer, and all is fine, when I run the job via the SQL Agent, [SQLSTATE 01000] appears after every line in the "log" file, any ideas ?

    This happens with the sp_help_revlogin procedure.

    both are being run with sa.
    Last edited by PMASchmed; 06-29-06 at 15:57.

  2. #2
    Join Date
    Jun 2004
    Location
    Long Island
    Posts
    696
    Known issue with the PRINT command in SQL Server.

Posting Permissions

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