Description:
Microsoft SQL Server newsgroup.
|
|
|
The merge process is retrying a failed operation made to article..
|
| |
I have one problem. Replication to one of subcriber in merge replication stop synhronizing. Both, publisher and subscriber, are SQL 2005 SP3. This hapens already one weak ago. Then i have tried to reinitialize subscribtions but it didn't work. So i have deleted publication and set up subscriber again. It... more »
|
|
|
Merge Published Date Column wont replicate/accept NULL.
|
| |
I have a table published using merge replication. There are a number of subscribers. One of the subscribers has a problem with a date column. When I try and set the value to a NULL (NULL's allowed in DB) at the subscriber, the value is accepted. But aftet the agent runs, the value is back to the value from the... more »
|
|
|
tabeldiff with views possible?
|
| |
Hi NG, for SQL2k0 I have wrote my own tablediff with sync scripts. I read that 2k8 comes with tablediff.exe. My transactional replication used horizontal (where filter) and vertical partitioning. On pub db there are the standard article views and on subsriber I have build the same views to compare with... more »
|
|
|
Linked server help
|
| |
I searched the group for 'linked servers and replication' and see one post back in 2005 about how replication does not create linked servers. I need verification on that. I have a linked server in production that is configured as "data access" = false. I now need to setup a linked server for another process but can't because this one... more »
|
|
|
Need to relocate Merge Publication DB to a new server.
|
| |
I have a number of merge publications on my 2005 DB with SP2. The server is currently located in our office and I am in the process of setting up servers in off-site facility. I cannot move the existing server to the new facility. Is there any way of doing a backup and then restore to the new servers and... more »
|
|
|
Howto find the Name of Logreader and Distribution Task
|
| |
Hi NG, MSSQL2k8 Transactional Replication How can I find with T-SQL for a known publication the name or ID of the related task for logreader-task, snapshot-task and distribution task, if the task was manually renamed. Thanks in advanced. Thomas
|
|
|
replication from backup file
|
| |
hi, how do this, i have server a and server b, a is publication adn b is subscription, i only select some tables to sync, but other no-selected tables may have some updates in server a. what is the good way to have complete server b sync with server a? backup data in server a every week and reintial server b... more »
|
|
|
A workaround for SS 2005 Replication with Partition Switch feature
|
| |
Hello there, Actually, subject tells almost everything. We have a database which is > 1TB in size and we use Partition Switch feature for some tables for archiving purposes. Now we would like to use a TDM application which is called (Oracle) Golden Gate with this prod system so that we would use another server as a reporting... more »
|
|
|
a table trigger and merge replication and nullable columns
|
| |
We're using merge replication, and there are triggers on tables in other databases that update a replicated table. There is an after insert trigger on 1 table, which updates values of several columns in a replicated table. It seems that when the trigger fires and updates columns to the replicated table, the columns that are updated to NULL... more »
|
|
|
euro symbol not replicating properly from oracle to sqlserver
|
| |
Hi, I have a problem regarding euro symbol (?) replication from Oracle to SQLserver2005. At oracle side we have a column containing ? (euro symbol). which is being replicated to sql server. The select statment for that column displays that symbol as (?) question mark. The column at oracle is varchar(512) and at sqlserver side is nvarchar(512)... more »
|
|
|
|
