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 |
|
Pinkesh
Starting Member
2 Posts |
 Posted - 2007-03-22 : 06:37:06
|
| In transaction replication setup in sql server 2000 with service pack 4, I have mentioned 2601:2627:20598 error codes as -skiperrors parameter. I want to know SQL query (command) when transaction replication get any of above errors. Unfortunately I am not able to find erroneous SQL query in any of MSdistribution_history, MSlogreader_history, MSrepl_errors tables of distribution database.Help from anyone else?Pinkesh |
|
|
Pinkesh
Starting Member
2 Posts |
Posted - 2007-03-23 : 06:27:49
|
Any inputs ?quote:
Originally posted by Pinkesh
In transaction replication setup in sql server 2000 with service pack 4, I have mentioned 2601:2627:20598 error codes as -skiperrors parameter. I want to know SQL query (command) when transaction replication get any of above errors. Unfortunately I am not able to find erroneous SQL query in any of MSdistribution_history, MSlogreader_history, MSrepl_errors tables of distribution database.Help from anyone else?Pinkesh
|
 |
|
|
MohammedU
Posting Yak Master
145 Posts |
Posted - 2007-03-23 : 15:50:01
|
| Replication errors should be stored in MSrepl_errors table but when you use -Skiperrors parameter... I don't think it will right to the table...Try enabling logging...How to enable replication agents for logging to output files in SQL Serverhttp://support.microsoft.com/kb/312292MohammedU |
|
|
|
|
|
|
-skiperrors parameter with error logging