Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Image Error In SQL

    I have a seperate table that holds employees pictures in it and for some reason I am getting an error all the sudden when I try to insert a picture. I never got that before.. Can anyone help please??
    Last edited by desireemm; 04-15-09 at 17:23.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    It would appear that your image size has grown roughly eight times what it was (or you've added replication, or possibly you changed to a new SQL Server).

    The fix is easy, but PLEASE think about this before you make the change... This can have relatively far reaching implications to replication performance.

    The problem is the default size limit for replicated data. Your machine appears to have the default setting of 65536 bytes per replicated column. This only affects TEXT and IMAGE columns, since nothing else can be large enough to have problems with that setting. IF you decide to change this setting, the code snippet you need is:
    Code:
    EXECUTE sp_configure 'max text repl size (B)', 655360  -- or pick another size to suit you
    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Thank you Pat

    I had forgotten that our techs are moving SQL server and our scanned documents over to its own server and one of the databases I created is there.

    Ok Now I understand thank you again

Posting Permissions

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