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 |
|
SqlShaun
Starting Member
14 Posts |
 Posted - 2005-02-08 : 09:59:55
|
| Hi everyone!If you can give me a solution to this problem then I will personally hail you as SQLTeam.com SQL Server GOD!Ok, we have a database, and a snapshot agent runs every night. excuse the my lack of technical knowledge (im a junior) so anyway, we have PDA user's who get their snapshot via GPRS from their device. But sometimes there are errors and we get "integrity violations" the only way to find the responsible table/data is to comment out each individual table/filter in the replication script, re-run it, and then try get a snapshot again, until the snapshot succeeds and then we know what table is causing the trouble and hence the data. How is there a way to tell what table is causing the problem instead of going through and commenting out each table and then syncronizing?Is there no SQL script out there that can go through a snapshot database and find the integrity violation causing table?Thanks! |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-15 : 21:01:25
|
| Please do not cross-post:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=45942 |
 |
|
|
|
|
|
There Must Be A Solution! Please Read(Replication)