Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-05-04 : 08:41:02
|
| Allan writes "I am trying to setup transactional replication between two servers. The problem that I am having is when I test the replication, I am able to make an update on my publisher/distributor side, but when the transaction is passed to the subscriber side I get the error message that the string or binary would be truncated. I have the stored procedures already setup on the the subscriber side ( sp_MSupd_user_identification ) in this case, which are as they were automatically setup. When i get the error the message the last command is {CALL sp_MSupd_user_identification (NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Replication@Test.com',0,NULL,11111,0x000020)} What i don't understand is if i copy and paste this statement into the query analyzer it runs fine and the update is made.Any ideas on what could be causing this?" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-04 : 10:06:17
|
try to regenerate the snapshot with an option to drop the subscriber's tablesyou should prevent update on the subscriber if this is transactional replication, you'll get into a lot more concerns when synchronizingquote:
What i don't understand is if i copy and paste this statement into the query analyzer it runs fine and the update is made.
--------------------keeping it simple... |
 |
|
|
tomy74
Starting Member
32 Posts |
Posted - 2006-05-11 : 07:22:29
|
| Hi,The schema replication is not compatible, you did a subscription and later on you added or dropped or updated some fields , you can regenerate the snapshot with an option to drop the subscriber's tables but you must take in considearation the data in the subscriber can be lost. can you tell me which version of sql server ?Thanks,Tarek GhazaliSQL Server MVP |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-13 : 11:09:51
|
you can manage this by reinitializing the subscriptions to the publication involved  which will trigger a new snapshot to be regenerated on the articles involved only--------------------keeping it simple... |
|
|
|
|
|
|
|
|
Transactional Replication