Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft . public . sqlserver . replication
This is a Usenet group - learn more
Find or start a Google Group about replication.
Group info
Language: English
Group categories: Not categorized
More group info »
Related Groups
Microsoft SQL Server newsgroup.
Low activity, Usenet
Microsoft SQL Server newsgroup.
Low activity, Usenet
Microsoft SQL Server newsgroup.
Low activity, Usenet
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 28640  Older »
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 »
By Gregor  - 3:49am - 1 new of 1 message    

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 »
By Kevin J  - Nov 24 - 6 new of 6 messages    

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 »
By Thomas Hase  - Nov 24 - 2 new of 2 messages    

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 »
By Paul  - Nov 23 - 2 new of 2 messages    

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 »
By Kevin J  - Nov 21 - 4 new of 4 messages    

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
By Thomas Hase  - Nov 20 - 7 new of 7 messages    

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 »
By some...@js.com  - Nov 19 - 16 new of 16 messages    

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 »
By Depp  - Nov 19 - 7 new of 7 messages    

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 »
By amarsh...@comporium.net  - Nov 19 - 1 new of 1 message    

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 »
By siddu  - Nov 19 - 3 new of 3 messages    

1 - 10 of 28640   « Newer | Older »

XML      
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google