Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2005-09-29 : 08:42:26
|
| When you look at the job outcome in Enterprise Manager there is a lot of text; but, if you look at the MSDB..Sysjobhistory table or any other view or proc that displays job information the text is limited to ~ 255 characters. Anyone know of a way to get the full text returned in a query?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-29 : 21:34:04
|
| Does changing the Tools..Options..Results..Maximum characters per column value to 5000 in Query Analyzer fix the problem?Tara |
 |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-09-30 : 08:10:01
|
quote:
Originally posted by tduggan
Does changing the Tools..Options..Results..Maximum characters per column value to 5000 in Query Analyzer fix the problem?Tara
Lol. Thats what I hate about new contracts. It's always a pain to setup everything to the way it needs to be.  Thanks. |
|
|
|
|
|
|
Job outcome text?