Help! Error message "Length of text, ntext...
-
I just set up snapshot replication on my server. Everything looked great until one of my users got this message when saving a record:
"Length of text, ntext, or image data (115756) to be replicated exceeds configured maximum of 65536."
I'm having a hard time figuring this error out. I'm certain it's because she is saving an image file within the record. The data type is image and is set to 16 for the size.
Can anybody please help me? I tried disabling Publishing and Distribution but it says Error 21122: Cannot drop the distribution database 'distribution' because it is currently in use.
I really don't want to disable it anyway.
All the best,
Dale
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
There is an option at the db level I think that configures the text limit, that might be it. The 16 bytes is a pointer to the real data.
Andy
-
sp_tableoption N'MyTable', 'text in row', 'ON'
-
use sp_configure 'max text repl size'
The default value for replication of text columns is set to 65536.
The setting takes effect immediately without a server stop and restart.
Chris
-
Thanks Hubertusk. I saw something like your suggestion yesterday on another forum. It looks to be correct so I'll give it a shot.
-
Hubertusk. Sorry about that last reply from sqlinsite. It was really from me. I've been using his computer in the office suite next door 'cause of my virus problems (Hence, the reason for wanting to do replication). I can never tell who is logged in to sqlservercentral.com. Anyway, I will try your suggestion.
All the best,
Dale
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
quote:
Hubertusk. Sorry about that last reply from sqlinsite. It was really from me. I've been using his computer in the office suite next door 'cause of my virus problems (Hence, the reason for wanting to do replication). I can never tell who is logged in to sqlservercentral.com. Anyway, I will try your suggestion.an easy way to check who is logged in could be 'MyAccount' -> 'User Profile' or 'Testcenter'
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Yes, that's true but when you are in the middle of replying to a message, there is no way to tell who is logged in. It's kind of screwy when you are sharing a computer.
All the best,
Dale
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
-
quote:
Yes, that's true but when you are in the middle of replying to a message, there is no way to tell who is logged in. It's kind of screwy when you are sharing a computer.hit CRTL+N (if you use IE) to create a new instance and look at it in the new instance.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks, Frank. That's a little more work than my brain can handle before the first cup of java.
All the best,
Dale
All the best,
DaleAuthor: An Introduction to SQL Server 2005 Management Studio
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply