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??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

IIS & SQL Server on Same Server - Risks??

I have a third-party application that requires IIS. The application will only be accessed internally by employees. What are the risks of combining IIS and SQL Server on the same server?
Thanks, DaveI have a third-party application that requires IIS. The application will only be accessed internally by employees. What are the risks of combining IIS and SQL Server on the same server?

Thanks, Dave

resource contention and security. you need to be worried about security internally. I have had problems with malicous users before.|||What are the security issues associated with IIS 6? I'm aware IIS 5 had a large number of issues, but I've read where IIS 6 resolved many of the issues.

Thanks, Dave