Post reply

Error running Stored procedure

  • September 13, 2010 at 7:34 am

    #238058

    When I run the stored procedure below I get an error message of:

    Msg 8152, Level 16, State 14, Procedure sp_table_ExportBatch2, Line 123

    String or binary data would be truncated.

    The statement has been terminated.

    Any suggestion will be appreciated

    ----------------------------------------------------------

  • September 13, 2010 at 12:04 pm

    #1220229

    I hope the following pounters may help:

    Judging by the name of the stored proc you are calling it is not part of SQL Server, but something omeone has written on your site. You need to look at the source of it to try and determine the cause.

    Running a profiler trace (with enough trace urned on to see the indiidual statements in the procedure) will help pin it down.

    Also is is not normally a good idea to use the prefix sp_ on stored procedures unless you actually want the special effects it brings. BOL describes the implications.

    You could try posting the entiore source, but without the table definitions and data it is not likely to help too much I suspect.

    Mike

  • September 13, 2010 at 12:08 pm

    #1220234

    Thanks. I was able to fix the error and your suggestion was helpful.

    Thanks again!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply