Help : Server: Msg 8152, Level 16, State 9, Line 1
Results 1 to 3 of 3

Thread: Help : Server: Msg 8152, Level 16, State 9, Line 1

  1. #1
    KUL Guest

    Help : Server: Msg 8152, Level 16, State 9, Line 1

    When I try to update one table from another I get the following error
    message, Does anyone know what may be the cause of the error :

    Server: Msg 8152, Level 16, State 9, Line 1
    String or binary data would be truncated.
    The statement has been terminated.

    Thanks

    KUL

  2. #2
    Vyas Guest

    Help : Server: Msg 8152, Level 16, State 9, Line 1 (reply)

    That error means that you are inserting data into a char/varchar column, more than what it can take.
    HTH,
    Vyas
    Check out my page for SQL Server, ASP, VB resources,Replication FAQ and
    MORE:
    http://vyaskn.tripod.com/index.htm
    Review of SQL Server 2000's "Federated database servers" feature:
    http://vyaskn.tripod.com/federated.htm
    Interesting code samples (include SQL stored procedures, VB programs):
    http://vyaskn.tripod.com/code.htm



    ------------
    KUL at 1/5/01 5:00:47 AM

    When I try to update one table from another I get the following error
    message, Does anyone know what may be the cause of the error :

    Server: Msg 8152, Level 16, State 9, Line 1
    String or binary data would be truncated.
    The statement has been terminated.

    Thanks

    KUL

  3. #3
    KUL Guest

    Help : Server: Msg 8152, Level 16, State 9, Line 1 (reply)


    Thanks for your help mate I will chek these websites

    Cheers
    KUL


    ------------
    Vyas at 1/5/01 5:57:53 AM

    That error means that you are inserting data into a char/varchar column, more than what it can take.
    HTH,
    Vyas
    Check out my page for SQL Server, ASP, VB resources,Replication FAQ and
    MORE:
    http://vyaskn.tripod.com/index.htm
    Review of SQL Server 2000's "Federated database servers" feature:
    http://vyaskn.tripod.com/federated.htm
    Interesting code samples (include SQL stored procedures, VB programs):
    http://vyaskn.tripod.com/code.htm



    ------------
    KUL at 1/5/01 5:00:47 AM

    When I try to update one table from another I get the following error
    message, Does anyone know what may be the cause of the error :

    Server: Msg 8152, Level 16, State 9, Line 1
    String or binary data would be truncated.
    The statement has been terminated.

    Thanks

    KUL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •