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 |
|
porcrim
Starting Member
13 Posts |
 Posted - 2004-01-24 : 18:33:47
|
| I have a SQL 7 server that receives replicated data from another SQL 7 server. The replication is working fine. The problem that I am having is that I want to set a flag on the records in one of the replicated tables on the subscriber. When I try to do an UPDATE from Query Analyzer on the table or any of the replicated tables I get an error that "Login failed for SA". I made sure that the table has the UPDATE rights granted to the login that I am using to connect in Query Analyzer. How do you do an update to a replicated table?Thanks,Matt |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-26 : 12:22:01
|
| If you modify data on the subscriber, then the data will not be the same. You need to modify the data on the publisher first and wait for it to get replicated over to the subscriber.Tara |
 |
|
|
porcrim
Starting Member
13 Posts |
Posted - 2004-01-28 : 18:43:43
|
| I found the follwing MSDN article that documents the problem and provides a solution.http://support.microsoft.com/default.aspx?scid=kb;en-us;320773 |
|
|
|
|
|
|
Updates to Replicated Tables