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??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:EXECUTE sp_configure 'max text repl size (B)', 655360 -- or pick another size to suit you-PatP|||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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment