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 |
|
yakoo
Constraint Violating Yak Guru
312 Posts |
 Posted - 2003-08-15 : 10:30:17
|
| I have a replication process setup where the distributor and publisher are the same machine. This process then runs Merge Agents to keep 4 seperated DB's in sync. I am having trouble with one of the servers.About 2 weeks ago I recieved the message 'The process could not query row metadata at the subscriber' (err no: -2147200996). To fix it I reinitialized the subscription and all seemed fine until 1 week ago when the problem happened again to the same machine. Well I repeated my solution to fix the problem. Well it happened again, and I would like to get this problem fixed but I can't find the root cause.I have searched around and read reports that this error message means there are communication failures or bad permissioning. How could this be if it has happened at pretty much the same time on the same day for the past 3 weeks. Any help/insight is much appreciatedGot SQL? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-15 : 13:07:31
|
| Yakoo, this sounds like a network problem or a server might be too busy. Since it is happening around the same time and same day, I would check to see what is occurring on the network or what is occurring on the SQL Servers. SQL Server could block people/other servers from connecting to it if it is too busy. I would run Performance Monitor (capture counters from both servers) around the time that this problem occurs. If that doesn't give you any information, then I would contact the network administrators to see if they have any insight as to what is occurring.Tara |
 |
|
|
|
|
|
Row Metadata