declare @P1 int set @P1=121 exec sp_MScheckexistsgeneration '633C29DB-678E-46C0-AD3A-E1609F33EC8D', @P1 output select @P1 We are testing merge replication for a database where the database can be accessed using a web-based application. We noticed that the above procedure is getting executed...more >>

I'm trying to get to a point where I can implement structural changes to a merge replication system. My plan is to ship copies of a subscription database to enduser outside the corp firewall and write some code to load the new subscription database. I've done the following: 1. create a su...more >>

Hello there In snapshot replication, all the tables that replicated are being created whith the schema on the publisher All the properties of the tables are being transfered exept: Primary key and constraints Is there a way to transfare this data also? ...more >>

How do schema changes actually get to the subscriber? I need to do an ALTER TABLE to add columns to a table on the Publisher and have the subscribers pick up the change AFTER they synch/upload their data changes. We are doing Merge replication to anonymous laptop subscribers. I am hoping th...more >>

Hi, I made a vb.net application that create a subscriber and subscribe it to an article that I have created. Yesterday when I start this application it took 2 minutes to create the subscriber and copy the database from the publisher to the subscriber Today I start the same application b...more >>

I have to edit a column in a table which is part of replication I have first tried to drop the article first but get the following error. Does this sound like a serious error in the system. I have also gone into EM and tried to untick the table in the articles section of the publication but it...more >>

Hi, I have set up a transaction replication. I tried to remove the subscription. I deleted the subscription using EM in the repliaction properties, even then when I go back and see the subscription server, I still see the subscriptions out there. I have a distributor in which the replication ...more >>

I have several databases in a merge replication. there are two servers linked so i can send data from one to the other. I mean Server Fenix is linked to Neptune. Neptune is replicating an Feniz is the Replicator. When one table in one of the remote computers is changed the trigger make pri...more >>

Hi, I'm Roby Eisenbraun Martins. I'm a C++, VB, C# developer. I'm developing a new application that requires work off-line from the database. I'm trying to work with SQL server 2005 replication, copying the data to a SQL Express database ( .mdf ), work off-line and then mer...more >>

i am using a combination of PULL and SubmitSql to synchronize data between PPC and back-end Server. I save the INSERT/UPDATE clauses in the PPC to send with SubmitSql later. Clients use GPRS. I am thinking to send the SQL scripts partially. it seems that sending one by one would be costly ...more >>

When I try to create a transactional publication, when I select the table I want to replicate, I get the error "This table cannot be published because it does not have a primary key column. Primary key columns are required for all tables in transactional publications". Then When I try to ma...more >>

How do I change the value in QueryTimeout? I have some wireless laptops that are timing out sometimes when they synch. Thanks. David ...more >>

Initially when I had setup my transactional replication I had created it with out taking a snapshot and by synching the databases. Now I am trying to add new table to one of my existing publication in production by creating scripts for ins, upd and del in test server and deploying it to sub...more >>

Mssql 2005 - Mssql2000 I try to create a "Transactional publication with updatable subscriptions:" But I can see that all tables cet an added colunm "msrepl_tran_version" Is it possible to replicate 2-way that wil not add this column (msrepl_tran_version)? What will happen if I set up "T...more >>

Mssql 2005 - Mssql2000 I try to create a "Transactional publication with updatable subscriptions:" But I can see that all tables cet an added colunm "msrepl_tran_version" Is it possible to replicate 2-way that wil not add this column (msrepl_tran_version)? What will happen if I set up "T...more >>

I just had to add a 2005 subscription to a 2000 publication that required a transform for the original 2000 subscribers ( table and column names were different between publisher and subscriber). When I tried to add the 2005 subscription in the 2000 publisher I got an error in the wizard sayng ...more >>

I have just created a Publication and now most or all of my triggers have been duplicated and given a name like ins_03FA9EAD39A54B18B6276581AA1F0C42. Is this doe in replication setup? Thanks. David ...more >>

Hello, I'm making some test of the Sql Ce Merge replication. The goal is to transfer a "per user" partition to devices. To problem I describe here occurs with Sql 2005 and Sql Mobile, but some old test showed that it occurs with Sql 2000 too and Sql Ce 2.0. I use the northwind DB with an ...more >>

Hello, Does SQL 2005 Std support multiple subscribers when utlizing log shipping? Thank you,...more >>

Hi I have transactional replication and I need a tables column data type changed from char(30) to varchar(40). What would be the best way and least dangerous to edit this column and get it to replicate the changes succesfully. thanks for any advice Sammy ...more >>

Hi there I wanted to know if thers is a way i can synchronize my foxpro database with sql server. this is what im doing know foxpro -> dts (delete,insert comands) -> backend sql database -> sql replication ->internet sql server. But the way i transfer the data from foxpro to sql is ins...more >>

What are the implications of database schema changes at the subscriber and not the publisher? We want to periodically synchronize our development databases with production data. There will be schema changes (addition of fields) to the subscriber that won't be promoted to the publisher until th...more >>

Hi , My Replication also got this timeout error while running the last command : {CALL sp_MSdel_SL030100 (N'BJX0047', N'26.01.06AF')} {CALL sp_MSins_SL030100 (N'BJX0047', N'26.01.06AF', N'535488', 2006-01-19 etc ..) i found out that SPid83 --> which is doing the sp_MSins_SL030100;1 is ...more >>

Generally If I use DTS to import data into a table which is in replication, data will not be replicated. (i.e. replication triggers will not be fired while using DTS!) This works fine for INSERTS! Is there any option in DTS which will NOT replicate the DELETES!...more >>

Hi, I have managed to set up continuous replication. However , i found out that when there error such as "general network error" the replication stopped. In such cases , won't it automatically re-do the synchronization ? and is there any way to allow auto-synchronization if the network be...more >>

I have been trying to find the limits of what Schema Changes I am allowed to make on a Merge Replicated Publication using SQL 2005. 1. Is it possible to rename a Table that is replicated using Merge Replication and have the schema replicated? 2. Is it possible to rename a Column that is repl...more >>

Hi, We have a customer site running merge replication with a publisher/distributer and 12 subscribers. All the merge agents are running in continuous mode. It seems that two of the agents are always failed, or don't last long. Is this directly related to the "number of concurrent merge pr...more >>

Hi, We are planning to have sql server failover clstering. Since server failover clustering is only for hardware redundancy not the databases. I still need 2 physical sql boxes(primary one is cluster server) by using replication or log shipping. My question is that why I need a expensice cl...more >>

Hello there Afrer i replicate my database, the tables that i replicated have been created with the owner of the user i've accessed to the subscriber database, instead of updating the data on my original tables that has dbo owner. Is there a way to use replication to update the dbo tables? ...more >>

We wil be upgrading all of our sql servers to new hardware and from Windows 2000 to 2003. The servers are in a merge replication topology. We hope to keep the server names the same. It would be an extreme hardship to drop the publications and recreate them. Given these parameters, what is...more >>

Hi, I have to replication a database with a merge replication type In that database there are 4 tables that I dont need on the subscribers I use a pull subscriptions I try to do a publication with out those tables but i received a message saying that those tables have dependencies on other...more >>

OK. lets say i have a 100gb db. I really just want to replicate 1 table within that db that is 65gb at like 100,000,000 rows(but who cares, we will use the entire db for this example). This is a production db that is constantly being updated. How would I be able to do something like a ...more >>

Hello, I'm a developer and I've inherited a sql environment that has 1 publisher, a distributor, and 12 subscribers. Several articles are published using transactional replication. I need to make a constraint change on a table that is published. Do I need to drop the publication and recrea...more >>

I would like some validation on a replication architecture. Business Context: We are deploying a custom .NET 2 application for an retail/distribution operation with 10 locations. The remote locations must have the ability to continue to operate even if the central site is unavailable (thes...more >>

I'm replicating a database from a SQL server in our DMZ to a server in the internal network. There is only a one way trust from internal box to external box (external box cannot see internal). I setup DMZ database as Publisher and Distributor. The internal box can only pull. When I initia...more >>

We are using SQL 2K with sp4 and push subscription. If I add a trigger or a Check contraint (or other contraints) for a column in a table that is already published in the publishing database, do or don't I need to do anything in the subscriber database? Please explain the consequence if I ...more >>

Hello all, I'm having problem with transactional replication - to replicate referencial intergity as well. I have database with 360 tables with 416 FK constraints containing "enforce relationship for replication". I want to use the transactional replication as part of disaster recovery pla...more >>

trans replication is it possible to replicate table without indexes to the subscriber’s table. lets say the source table has 20 columns with 10 indexes (1 clustered) and i want to replicate only 10 columns without any indexes [as i want to create them manually at the subscriber], but 5 in...more >>

Hello All, I am trying to assist a client with a replication problem, We have 2 SQL Servers which are remote to each other and connected via a VPN Tunnel Replication between the two servers is working correctly However they have had various power outages and internet outages which has ...more >>

I added a large table to our merge pub, 3.4 million rows. Snapshot ran rather fast, merge agents pushed rows out to 7 subscribers quickly. All looking ok. Begin testing. Inserts at subscriber not being replicated. Look at merge agents, change profile to Verbose. They are all displaying 0 i...more >>

I'm using SQL 2005 Standard and have a merge replication of 1 database with 3 tables being sent to multiple computers. I would like to display to the user in a web app when the last synchronization has occured. I assume time of the last replication for the database and/or tables is stored in ...more >>

I am reviewing my firewall logs and I have a boat load of inbound mssql data returning to my distributors as far as bytes received. Why would this be? Figured the traffic should be outbound only. tia -comb...more >>

hi, all Sql data mirriring. There is any sql server drives mirriring. means that not only hardware redundency but the sql data redundancy. When users updating through front end apps, it updates the both mirriring drives. Is that true? Thanks ...more >>

Hi, I am new DBA doing my first replication troubleshooting. we have a log shipping application that takes a snap shot of the origin tables, and generate 4 articles. Four tables are then synchronized using a merge agent, which runs every hour to destination database. We have taken the lo...more >>

i am trying to set up a transactional replication using two machines : one machine (A) for dist. and subs. the other is publisher(B). log reader runs on machine A. and gives this error : SubSystem Message - Job 'B-pubmachine-1' (0xEB8B08C1E6E6F044A1DB28C5AFC8850C), step 2 - The process could...more >>

Hi, In the flowering simplified example there is three tables. ProjectAssignmentTable, ProjectTable, and ProjectTransactionsTable. The idea is that an employee is assigned a project in the in the assignment table and he or she uses merge replication to replicate the project and transaction...more >>

The publisher has been disabled. But on the subscriber, I'm unable to delete the subscription. It was a merge. I tried to use sp_dropmergesubscription, but I've been unable to find a good syntax example. And from which place do I run it? Thanks in advance for any help. Leah ...more >>

Hello All I just want to ask what are the changes , if there are any, of the Merge Replication Procces from sql server 2000 sp3 to sql server 2005. I am going to start a new project with handheld devices that are going to sync ona replicated database and i want to do it on sql 2005. I kno...more >>

Hi, 1. I need to configure automatic stop of the distribution agent for transactional replication and start in 3 hours in order guys could run their reports on the replicated site. This means that distribution agent should run all the time except the time 7.00-10.00, stop automatic at 7.00 ...more >>

Hi All, I want to know when dbo.MSdistribution_history table will be created and where it will be present (under master database or any other database)? I think this table will be created when you enable replication on your SQL Server and will reside under master database. Please c...more >>

I am trying to setup replication in a server to server environment, and am using read only transactional replication to try and have a live and up to date version of our DB running on a second server, if perhaps the primary server would fail. Here is the setup: 2 Windows 2003 Servers both runn...more >>

Hi, I have one question concerning row filters. I use a row filter on a table by adding a "where" condition like Select ... From nyTable where id=1 I do this because this table is large and on the subscriber's side and we don't need it. I could just take out the table from the replica...more >>

I have a replication system with 4 computers. All of them are sinchronizing perfect. I have 3 diferente publications with diferent articles in each. One of these machine is given an error message in one of the publications... the other publications on this machines are ok. the process could...more >>

Since my merge agent was stopped for more than 14 days, when i try to start it now i am getting the message SUBSCRIPTION EXPIRED. How to solve this problem?...more >>

Hello there I have destination database which i'm not db_owner on it but guest The user i'm using to access between two servers is: 1. Source is connected by linked server to destination 2. on the destination none of the servers roles are active for the user i'm trying to access 3. the us...more >>