April 8, 2003 at 1:25 am
Hi folks,
I wrote a stored proc using PRINT-Statements to output messages. In Query-Analyzer everything works fine, but when I execute it in a Server Job there is a '[SQLSTATE 01000]' appended to every message. How can I get rid off this?
Thanx,
BB.
April 8, 2003 at 6:31 am
Can you post the conde inside the job that you are executing?
April 8, 2003 at 8:03 am
quote:
Can you post the conde inside the job that you are executing?
Hi Rodrigo,
in the Server-Job I simply put "exec sp" where sp is the stored procedure.
The sp looks like:
create procedure test_sp as
print "Hello World"
go
If you start such a sp in Query Analyzer you get "Hello World" as result. The logfile with the output of the server job shows "Hello World[SQLSTATE 01000]".
I want to get rid of the Appendix "[SQLSTATE 01000]".
cu.
December 11, 2008 at 2:51 pm
I HAVE THIS EXACT SAME PROBLEM, and have searched high and low for the solution! NO LUCK SO FAR! I am running a simple SQL query that produces a delimited file for output to another vendor. I am sending them this file, and they do not want to see [SQLSTATE 01000] at the end of every line! It only happens when I run it as a SQL Agent job, in query analyzer, it runs fine. Surely there is a simple fix for this, right???? PLEASE HELP!!!!!!!!!!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply