|
|
|
Welcome to www.ReplicationAnswers.com
- a community resource for SQL Server DBAs who are interested in
learning more about SQL Server replication....Please send any comments about articles etc to Paul.Ibison@ReplicationAnswers.Com. |
| |
| |
|
|
|
Consultancy....I'm getting a lot of emails
asking for advice and help with replication. Sometimes this
is from big firms (most recently the Royal Bank of Scotland)
and sometimes small firms (a local veterinary practice!).
Doesn't matter to me - I like all this sort of work! Please
refer to the separate page if
this might be of interest to you. Also, mostly this is done
remotely so where you are isn't an issue. |
|
|
Below is a list of the most recent additions to the site.
|
| "Error # 5 was generated by .Net SqlClient
Data Provider The insert failed. It conflicted with an
identity range check constraint in database 'DB',
replicated table 'dbo.Table', column 'ID'. If the identity
column is automatically managed by replication, update the
range as follows: for the Publisher, execute
sp_adjustpublisheridentityrange; for the Subscriber, run
the Distribution Agent or the Merge Agent. Unable to
insert [dbo].[Table] The statement has been terminated."
This error was produced on the publisher sopradically
- we would get some errors and then it runs ok - without
an obvious pattern. What is the solution? |
Merge |
11/3/2013 |
| Updated scripts |
Scripts |
02/12/2012 |
| Optimizing hte initialization process |
Articles |
26/12/2012 |
|
