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 |
|
SteveH
Starting Member
27 Posts |
 Posted - 2010-04-19 : 16:52:46
|
| I have tables on server1 being replicated to server2 by push. When I took over this system, an issue lead me to run the tablediffs utility on 6 tables. Server1 tables have the schema dbo.table1, dbo.table2, etc. On server2 they are server2repl.table1, server2repl.table2, etc. On half of the tables, the tablediffs utility errored out stating that the tables could not be compared because the schemas were different. I re-imported table3, one of the problem tables, to ensure the schema would be the same. The problem was solved until another issue forced me to drop and recreate all of the subscriptions. Now table3 has the same schema conflicts when tablediffs is run against it.Any ideas why?Table3 on the subscriber side does have indexes different from the publisher side but none of the other problem tables do.Thanks,SteveSteve |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-04-20 : 00:19:04
|
| check if someone is modifying the schema on the subscriber? or perhaps theres a job running modifying the schema? fire up profiler and catch the burglar.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
SteveH
Starting Member
27 Posts |
Posted - 2010-04-20 : 11:02:45
|
| Dinakar,Thanks for the reply. I am not well trained in SQL Server yet. How do I find and use the profiler?Steve |
|
|
|
SteveH
Starting Member
27 Posts |
Posted - 2010-04-20 : 11:06:24
|
| I found it. I will read up on it.SteveSteve |
|
|
|
|
|
|
Schema-replication issue