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 |
|
chrispy
Posting Yak Master
107 Posts |
 Posted - 2002-03-08 : 21:48:53
|
| All, I am trying to set up replication of two SQL 2000 servers. I went through trying Snapshot, Transational, and Merge types. Seems I kept on getting an error. "Invalid column name "T" error 207". Further attempts and I was able to determine that it is the Stored Procedures that is causing the error. Learning from this I am able to assume that all of the SPs are validated before they are replicated. Seems these errors cause the whole replication process to halt?????? Two questions arise. Is there a way to turn this off. Secondly How do I find the SP that contains this error. The above message is all that I can go by. Looking ahead does this also mean that if someone creates a SP with an error that the replication will halt??? I would hope not.Any advice appreciated.Chris |
|
|
|
|
|
Replication errors on SPs