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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Immediate-updating subscriptions

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-04-21 : 22:27:04
Louis writes "I have setup Transactional replication with "Immediate Updating Subscribers". Changes on publisher get replicated to the subscriber, without any errors. But when I try to UPDATE data at the subscriber I am getting the following error and not able to modify data at the subscriber:

Server: Msg 137, Level 15, State 2, Line 5
Must declare the variable '@c123o'.

Not positive.... but I believe it has somthing to to with the update trigger on subscriber table?
How can we correct this problem?

Any info would be appreciated.
Sincerly,
Louis"
   

- Advertisement -