insertin BLOB in to database?

[nowayout]

Hi I am trying to insert a blob in to database so for that the datafield and datatype are DFile and image. but now the table option should text in row "ON" or "OFF" i don;t know. What should it be.

Thanks

 

[fluteplr]

Unless your blobs are very small (under 8k) setting it on will not do you any good. Store image in row attempts to store small text and image fields in the database row instead of the default way (in a separate part of the database)

 

[nowayout]

the blob are big which is in MB or may be higher but what should i do for that?

 

[eramgarden]

From what I've read, you shouldnt store blobs in the database. Instead, store a link to the blob.

We're storing blobs in the database, Not good, not good at all. But too late to go back.

 

[nowayout]

yeah i am on the same side of the cliff too that it's too late to change it so what should i do about it. would you guide me please..

Thanks

 

[nowayout]

The error i am getting is
"SQL SErver Message 7139: Length of text, ntext, or image data (374738) to be replicated exceeds configured maximum 65536"

How can i solve this error? please help me!!!

thanks

 

[DBADoug]

This will correct your problem ... check out BOL.

sp_configure 'max text repl size','393216'
go
reconfigure with override

 

[nowayout]

where do i have to run this on the db which i am wokring on?

thanks

 

[DBADoug]

You can run this in a QA session on the server that your datbase is running on. This is a server configuration setting, and not database specific ... give it a try. Note that the size parameter is adjustable to fit your specific needs. You can set it to what you feel is appropriate.

Doug

 

[nowayout]

Thanks