SP_HELP_JOBSTEP throws String or binary data would be truncated Error

• Jayakumar Krishnan

  SSCarpal Tunnel

  Points: 4710

  More actions

  July 8, 2009 at 3:59 pm

  #95821

  We have a code to collect all jobs & Job step details from different servers under our support. I'm using the system proc sp_help_job to collect job details which is calling internally the sp_help_jobstep proc. On one of our server I'm getting this below error when the proc executed.

  Msg 8152, Level 16, State 10, Procedure sp_help_jobstep, Line 95

  String or binary data would be truncated.

  Anybody experienced this issue any workaround?

  Thanks in advance...

  Warmest

  Jay.

  Thanks
  Jay
  http://www.sqldbops.com

• Jason Selburg

  SSC-Insane

  Points: 24641

  More actions

  July 8, 2009 at 10:58 pm

  #1022141

  What's on line 95? 🙂

  ______________________________________________________________________

  Personal Motto: Why push the envelope when you can just open it?

  If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

  Jason L. Selburg

• dennis.oconnor

  SSC Enthusiast

  Points: 149

  More actions

  July 10, 2009 at 10:23 am

  #1023189

  You get this error when you are trying to put a value into a column that is too small for the value.