May 12, 2010 at 8:58 am
After creating a merge-publication or snapshot-publication and reviewing the job status the following error is displayed in the job:
Message
Executed as user: domain\someuser. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.
Any ideas?
May 13, 2010 at 12:27 pm
I can only assume that you have a design problem with some of your tables.
* Noel
May 14, 2010 at 4:34 pm
This is kind of vague. I think we will need more information to be of more help to you. Table schema, replication setup, exact error received, etc.
Joie Andrew
"Since 1982"
January 20, 2011 at 9:45 am
Hello,
I am having similar problem. it throws following error while doing snapshot.
Message
Executed as user: <login>. String or binary data would be truncated. [SQLSTATE 22001] (Error 8152). The step failed.
mine is SQL 2008 standard edition on 64 bit windows 2008 server.
does anyone know how to resolve it?
Jatin Soni
January 21, 2011 at 8:53 pm
Could be that the publisher and subscriber table has different table schema. Specifically, subscriber's table probably has a smaller column data type than the publisher's. E.G. : if the Publisher's Table1.Col1 is varchar(12), the Subscriber's Table1.Col1 could be varchar(11) or less. Also, if you are distributing transactions through stored procs, then the variable in one the procs for a specific article may have an incorrect datatype size.
January 22, 2011 at 5:39 am
Schema is same on both the servers. Actually I had created different windows login (other then admin) and using it in replication. When I have changed it back to Admin user, then replication worked without any issues. so error which MS gave was wrong as it was actually a login issue. not the schema issue.
January 25, 2011 at 4:01 pm
I think what nadabadan posted makes a lot of sense and would probably be the first thing to at least verify before investigating a lot of time in another area.
Joie Andrew
"Since 1982"
September 14, 2011 at 10:39 am
Hi jatin-243645
I have your same problem!!
I'm running my application from different SO (now 64 bit and sqlserver2008) and i have this error while attempt to call a storeprocedure.
The code it's the same as the machine where it run ok.
Have you solved this issue??
thank you
Gianni
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy