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 |
|
nbpatil
Starting Member
14 Posts |
 Posted - 2004-10-27 : 08:12:29
|
| Hi..1)I have set transactional replication (SQL 2000) from db1 to db2.My initial snapshot transfered data from db1 to db2.When i try to insert some records in db1, then Distributor shows error 'Syntax Error or Access violation' .This is No.37000 of SQL server.I am using proper user account with required permissions.What could be the reason for this error.2)I have SQL 2000 Standard Edition.Anything in SP3 or SP3a will help to improve REPLICATION performance.Anybody experienced better replication after SQL 2000 service packs upgrade.Thanks & RegardsNitin Patil |
|
|
nbpatil
Starting Member
14 Posts |
Posted - 2004-10-27 : 08:13:36
|
| 37000 is the Error number generated by SQL 2000. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-27 : 22:22:47
|
quote:
Originally posted by nbpatil
Hi..Anybody experienced better replication after SQL 2000 service packs upgrade.
still the same after the upgrade... can you post your insert syntax? i googled the error, and it's showing what you just posted, syntax error.--------------------keeping it simple... |
|
|
|
|
|
|
Sharing Violation error on Trans.Replication