Hello, I tried adding a column to my test replication DB. Here is what I tried and the error message I kept getting: sp_repladdcolumn 'websubscribers', 'newcol', 'varchar(50)', 'pubwebsubscriber' >> ODBC: Msg 0, Level 19, State 1 SqlDumpExceptionHandler: Process 56 generated fatal exce...more >>

Hi i am configuring a replication Server, i created the publication and when i want to configure web synchronization i get the following error when the process is setting the snapshot share permission: The operation completed successfully (Exception from HRESULT: 0x80070) I already defined th...more >>

Hello, I appologize in advance if this question is way too lame, but I have this transactional snapshot respication job, and here are a few lines of the sql from the generate sql window from the properties of the replication job ---------------------------------------------------------------...more >>

I'm looking for any advice/help with the following situation: We have a SQL Server 2000 server outside of our firewall which our vendor can access. The vendor updates data, and we wish to replicate this data through the firewall and into our internal SQL Server 2000 server. The firewall w...more >>

Hi all, When i run the script for merge replication (adding article): exec sp_addmergearticle @publication = N'TestPublication', @article = N'TestTable' , @source_owner = N'dbo', @source_object = N'TestTable' , @type = N'table' , @description = null, @creation_script = null, @pr...more >>

Dear all, Currently I am working on a immediate updating subscriber for transaction replication. After solving the MSDTC issue, I got an error "Could not change the publisher because the subscription has been dropped. Use sp_subscription_cleanup to clean up the triggers". After reading a pr...more >>

I want to simulate replication on lines with high ping time, like lines between Sydnay and Chicago. In order to be able to emulate hardware compression, I want to use something. Are any utilities which compress network traffic?...more >>

Hi, I'm using the RDA replication between sql server mobile and sql server 2005. The replication works very well but now i'm facing another problem, i'm trying to generate dataset on the replicated tables but when finishing the wizard i always get the error "Dynamic SQL generation for the...more >>

We have a fairly large database that we attempting to setup transactional replication on. Just to restore a copy of this database took almost a day. What is the best method for establishing transactional replication on a large database? Should we set it up and run the initial snapshot the w...more >>

Merge replication is taking place between hand held clients running SQLServerCE (anonymous subscription) and a SQL Server 2000 box. We have a stored proc that executes nightly (scheduled job) archiving records older than 90 days on the SQL Server 2000 database. What we have been finding is that...more >>

Server (distributor and publisher) SQL Server 2000, client MSDE XP Pro. I create a merge subscription on the server. Many tables have row filters. The client machine starts its software the first time, so it creates its database and then sync's the data. This FIRST time, I need to get all data...more >>

On a handheld device (ipaq) I'm creating a sql db using merge replication. The subscription works fine. In my testing, I have created several subscriptions and need to get rid of them on the server. Replication monitor shows them, but I can't figure out how to delete them. I tried program...more >>

Hello, I took over a project several months ago. I am a basic Client/Server app developer. I have experimented a little with replication and am currently studying a book on the subject of replication, but otherwise have no real industrial experience with replication. Today I just notic...more >>

Hi all! I want to some answers about Merge Replication. 1) What is the maximum numbers of subscribers used in Merge Replication? (i heard that max. of 600 subscribers are used). If this crosses then what is the alternate way of syncronizing data between servers.? Any help is ...more >>

Hello... Using SQL 2005 merge replication and we are currently replicating data between the server and multiple (100's) of subscribers that use a PDA (running SQL Mobile). I have to now change the replication to support a non-standard port, Port 8080, in this scenario. And try as I have...more >>

Hi I am having a big problem I am contracing on a public sector project that is importing Oracle data to SQL server however we do not have a direct connection to the source data but we do have an old copy of the database on a local oracle server we have a target schema defined however we are not...more >>

I have two sql 2000 machines that I am trying to replicate between using transactional replication. For some reason the custom stored procedures are not being created in the destination database. Replication works fine if I turn these off. Anyone know why these might not be created?...more >>

Hello, my snapshot agent never manage to successfully execute. It generates the error at the System Event Log The server {3D14228D-FBE1-11D0-995D-00C04FD919C1} did not register with DCOM within the required timeout. and this in the Application Log SubSystem Message - Job 'mws-cpmord...more >>

We have been using Replication in a strange way for 5 years now. I call it strange because I would not have set it up that way, but it was done and remains so till date. The idea then was to bring scalability and failover protection to the databases by setting up n SQL server 2000 boxes an...more >>

I'm getting the following error message when I attempt to replicate a particular stored procedure. Insert Error: Column name or number of supplied values does not match table definition. I have enabled logging (level 2) on the distribution agent which helped me determine it was in fact t...more >>

Hi, I´am looking for the time between replication, I supposed the trigger was a change in the database but it looks different. Can I configure this somewhere ? regards //Eddi...more >>

Hello All, Does anybody use the Double-Take software to do the database replication? Currently I use the Transaction Replication in SQL Server2000 but it does have an automatical failover feature. What is the downside of using the Double-Take over the Transactional Replication? Thanks,...more >>

Hello: I did a test (in our labs) upgrading sql 2005 workgroup build 1399 to sql 2005 dev edition 2005 build 1399-- and it broke merge replication to the subscribers.... just said expired or does not exist on the subs my production situation: I'd like to go from sql 2005 workgroup to sql ...more >>

Wow, I didn't see this limitation in the version comparison, this is a big problem!! Also you can only have 25 per *SERVER*, not per publication AARGH!! ...more >>

We have both ASA (Sybase SQL Anywhere) and MSSQL. We are considering moving everything from ASA to MSSQL but replication is an issue. At this point, most of our databases reside in ASA and get replicated to multiple remote sites via FTP. The majority of the remote sites are developers hen...more >>

Hi, I need to do replication between a sql server 2005 express database and sql server mobile. I search in the msdn and i read that sql server express can only act as subscriber. But in other hand i also read in a forum that this is possible using the RDA replication method. Could anyone...more >>

I need to replicate a table structure "exactly" as it is, including primary key, foreign keys, constraints, and indexes. I’m having problems figuring out the correct @schema_option setting though? Thanks, Mark ...more >>

Hello, I want to try to simulate transaction replication with limited network bandwidth and network delays conditions. I have program which do it for specified ports. Is it possible to configure replication to use proxy to be able to use the program.? Which ports are used by repliation? ...more >>

Hi, i have created a merge publication on the server (SQL 2k5 Standard). serveral subscribers (SQL 2k5 Express) sync over the Internet. As they don't have fixed IP address, so that i have enabled the anonymous subscription at the publisher. What else do i need to do to make it work? Is the...more >>

I am currently trying to set up my development machine as a Distributor and I am encountering the following error when viewing the Distributor Properties. Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. (.Net S...more >>

Hi all, I have an oracle publisher and subscription DB in mssql2005. How does the transaction replicate to MSSQL2005? e.g. record A1, A4 are the records in tab A , record B2 from tab B and record C3 from tab C and their commit sequence is A1, B2, C3 , A4 in oracle and they are now ...more >>

Good day, I seem to be having issues with subscribing to a publication. The actual error that I get on running the subscriber job is: "The job failed. The Job was invoked by User sa. The last step to run was step 1 (Run agent.)." The agent process account is set to: "SQL Server Agent acco...more >>

I was able to create database maintenance plans for log shipping successfully and everything is still working fine. I created new ones but this time, the jobs don't run. I couldnt even force them to start manually? Has anyone had this problem before? -- MCP MCDBA MCAD MCSD MCT MCTS:SQL S...more >>

I have a 750mb database I need to post to a separate webserver on a daily basis. The timliness of the data is not an issue. The client is accepting a 24 hour delay in the availability of the data (it doesn't change all that much on a daily basis). The idea here is to make the transfer and updatin...more >>

Environment: Publisher is SQL 2000, Distributor is SQL 2005 Please note: I have changed the user name, the publisher name and the database names in the following text. When I attempt to create a new publication, using either SSMS or EM, I receive the following error: Could not obtain inf...more >>

Following are the three questions for which i need answers, Help in this is heartly appreaciated. 1. It is mentioned in replication, that CPU, Disk and Memory Utilisation need to be moniotored. In which scenario we need to check that, like when replication fails or it should be checked freq...more >>

in a mirrored setup, it was very easy to setup notifications on the two partners based on WMI alerts. However, does anybody know if it is possible to setup alerts on the Witness, in case both the primary and mirror server both go down at the same time, but the witness remains alive? Thanks, ...more >>