Re: Create Custom Error Message
From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 02/26/04
- Next message: Craig Buchanan: "bitwise operation questions"
- Previous message: Chip: "sendmail - ssl"
- In reply to: jason: "Create Custom Error Message"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 26 Feb 2004 21:43:36 -0000
That is a display limitation. As you figured, you should have the job output
to a file. Or simply write out error messages to a table, and at the end of
the job, export that table out to a file using BCP or DTS.
-- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ Is .NET important for a database professional? http://vyaskn.tripod.com/poll.htm "jason" <jasonl22@yahoo.com> wrote in message news:458a6e24.0402261211.2dff7d3d@posting.google.com... When viewing the job history in sql server 2000, after you click on the step ID, log data is displayed in a window at the bottom of the GUI screen displaying the error message. I am raising a custom error message via a T-SQL statement using RAISE ERROR to write to this window. This works for jobs that have fewer details. However, when I raise an error using the T-SQL statement for a job that has many details, the error message I create gets truncated. If I write it to a log file, I can see that my custom message does in fact get written to the log. My question is, can the character or line limit of this display limit be increased to show all of the data that would display in the file (or just more data)? Is there a way to display data in this window in any other way except using the RAISE ERROR T-SQL statement (i.e. vbscript in activeX object)? thanks.
- Next message: Craig Buchanan: "bitwise operation questions"
- Previous message: Chip: "sendmail - ssl"
- In reply to: jason: "Create Custom Error Message"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
