I have a client that desires a new application for use at several stores in different cities. He wants "real time" access to all store data and the ability to continue to run locally even if the internet connection goes down. It occurs to me that a local SQL Server 2005 instance should def...more >>

I am new to SQL Server replication. For some reason, in Microsoft SQL Server Management Studio (for SQL Server 2005), if I run an "alter function" statement, "alter procedure" statement, or "alter view" statement, for an object that is an article in a merge publication, the command never fi...more >>

Hi, I'm setting up a three-tier replication. The top tier is a corporate server running SQL Server 2005 STD. That is setup as a publisher. The second tier is many district servers running SQL Server 2005 STD. Those are setup as subscriber/publisher. Within each district are many offices runni...more >>

Hi, We have Merge Continuous replication. Every couple of days the Merge agent stops with an error: The process could not enumerate changes at the 'Publisher'. Source: Merge Replication Provider (Agent); Error number: -2147200999 We are running on SQL2000 Standard, SP4. The OS is Windows 2000 S...more >>

Friends, have any one set up above said techs between datacenters (2 or 4, more). please evaluate pros and cons. Thanks,...more >>

Hi, Nearly 100 tables are in merge replication and I need to remove 5 tables from replication. Is it possible? If so what are the steps I have to follow? Please advise. Thanks, Soura...more >>

Hi, We are looking at implementing Transactional replication for our production. The initial set up did not work for us becuase the generation of snapshot was having serious slowing down of production. We cannot take our site down just for generating multiple 40G database's snapshots. My ...more >>

When I look at my publisher and the publications in EM, they say they are transaction replication. HOWEVER, when I run sp_helppullsubscription on both of the subscriber DBs, they return a publication_type of 1 (well except for one of them which returns a 0 and is the one causing me high latency ...more >>

I am developing a transactional replication plan. I have one table that most of the time I do not want to replicate deletions. There is an exception to this rule. If the status_id of another table is false, then the deletion should be replicated. I have been having difficulty trying to put ...more >>

Hi everyone, I have a problem with one of my publishers. When I click on the "Articles" tab under the "Publication Properties", I see all my articles but everything is greyed out. I can't uncheck any of the articles and I cannot add any. I need to add one more article to the publication! ...more >>

I am trying the snapshot replication. The publication and snapshot agency in a SQL Server 2000 machine and subscription in a SQL server 2005 machine. Is it possible? I could not made it work. I found I could only Push 2005 Publication to 2000 subscription. (Pull not working) Thanks ...more >>

It seems every time a snapshot is made the next scheduled run is disabled and listed as "unknown" on the status tab of the agent properties. Once I go back into the schedule properties and re-enable, it runs that night but then goes back to unknown the next day. Any ideas? I've seen similar post...more >>

I have an application that has been using a right outer join that worked as I expected until I added merge replication. On the replicated database the result is the same as an inner join. I could be doing something odd but it's a pretty plain use and it still works on instances of the database...more >>

Recently I have experienced problems with subscriptions getting out of sync. Some of the published tables are very large and are connected to the subscriber via t1 connection. To avoid re-initializing the entire publication I ran sp_dropsubscription followed by sp_droparticle, both specifying ...more >>

SQL 2000 trans replication. I have a fat table (100+ columns ) being replicated minus a couple columns. . How do I query the replication sys tables to find all columns being replicated? Goal is to find which columns are NOT replicated. Thanks in advance, Chris...more >>

After installing SP4 on distrib and publisher (subscr SP3) on one article in merge publ a problem of bitmap occurs when updating one column on subscriber : i updated col44 of the table on subscriber, i saw on trace that the repli applied update on col43 any clue? TIA bruno ...more >>

If I have applied a database dump to the subscriber for a no-sync database that is using snapshot replication, do I need to keep applying new snapshots? The distribution agents seem to be "delivering transactions" but not as many as when I used transactional repl on the same database (this was n...more >>

How can I get a list of all the triggers associated with a particular table in a database. And in addition, how can I get a list of all triggers for the entire database (meaning all triggers associated with all tables)? Thanks!! -- Regards, Troy...more >>

Hi, I create a column in a table that is in a merge publication with this code USE JMI GO sp_repladdcolumn @source_object='ztest',@column='dateDepart',@typetext=' datetime NULL DEFAULT getDate()' ,@publication_to_add='JMI_articles' GO I realise that a made a mistake and i want to dro...more >>

Hi Guys, I have recently removed replication from the SQL server (2k) and everything seemed to be working at first. Initially, the database still contained all the conflict tables etc... but I got rid of all those. However, now, when attempting to insert into some tables in the database...more >>

Hi, Just completed the transactional replication and when tried to test the changes made in the publisher data it (Distribution Agent) failed with the following error: ----------------------------------------------------------------- Could not find stored procedure 'sp_MSupd_ACCOUNT'. (Sou...more >>

I need to delete a transactional publication (no subscribers) and the associated database. I have tried to use sp_droppublication and sp_replicationdboption without success and I believe that this is due to some of the conflict tables being deleted from the published database. Is there any...more >>

I have more than 500 databases on my sql server 2000 enterprise edition. I have already suffered the deadlock problem mentioned in http://support.microsoft.com/kb/246330 So, I tried to upgrade to sql server 2005 but still unable to implement transactional replication for large number of databa...more >>

Is there a way to add the "Not for replication" switch for triggers and foreign keys other then dropping and adding them again? Thanks in advance, Pauly C...more >>

I have a SQL 7 database who's log is growing and cannot be truncated. It is a copy of a database from another environment and is involved in Transactional Replication. When I try to run sp_repldone, it says the database is not published (which is true). When I try to truncate the log with n...more >>

Hi, I'd like to keep an extra copy for database X on SQL server A to SQL server B. The database X doesn't update very often during the day (but the computer does have other jobs to run at tthe work hour). Both server A and B run SQL server 2000 and on the same network. Currently the size...more >>

Hello, Does anybody know a sp like Sp_repladdcolumn to change a column size without having to bring down the replication. Thanks in advance, Mathew ...more >>

Hi, I dont understand why when we drop a column we dont have to mention in which publication we want to drop a column We have to mention in which table but not in which publication So if we have 2 differents publications in 2 different database and in each database we have a table tEmploye...more >>

Is it possible to define 2 merge publications that contain same tables (one publication has dynamic filters, the other hasn't) and to subscribe the same DB to them? --- Details --- I have a HQ DB on SQL Server 2005, and a couple of hundreds of client DB's, installed on laptops with SQL Ser...more >>

All Is there some simple way to check if a database is being replicated that I can use in a script? I have 2 copies of a production database, one under replication and one not, and I would like to have any schema change scripts check for replication to see which action to take. E.g. <s...more >>

Hello it's possible to create a Merge-Publication with vertical Filter on an Sql-Server 2000 with SP3? in our developer System with SP4 i can make a replication, but in the Target System i didn't. Error 20009 add the article.... Thanks Daniel ...more >>

Environment: - Publisher: SQL 2000 (SP4) - Distributor/Subscriber: SQL 2000 (SP4) - Replication: Transactional/Continual updates Issue: Calls to sp_repldropcolumn are generating the following error: Server: Msg 4932, Level 16, State 1, Line 1 ALTER TABLE DROP COLUMN failed because '_column...more >>

Hi, I'm new to SQL*Server and implementing Transactional Replication. The active production database is in Sql Server 6 to be upgraded to Sql Server 2000 @ Windows 2003 with Transactional Replication feature. The plan is to build a new server, create the database using scripts from the pr...more >>

Hi, I have Database which is configured as a Merge Publisher , This database has 3 Tables Employee,Dept and Country. All these 3 tables are repliated to another database for high availability purpose using Merger Replication. The Merge Publisher is also an Subscriber for another Transact...more >>

Hi I'm trying to setup a push replication between 2 servers on different networks. both machines can ping eachother using there machine names. I setup the publication and the distributor on the push server and generate a snapshot. I then run the distributor but it fails to connect to the sub...more >>

I have remote offices that are entering data into their local database, then using merge replication to "upload" their changes to a publisher on my web server, and then possibly download any changes made on my web server. My Web server is running SQL 2005 Standard, and the local offices are r...more >>

I am trying the snapshot replication. The publication and snapshot agency in a SQL Server 2000 machine and subscription in a SQL server 2005 machine. I set both SQL Server' Security to Window authencation mode. I create a test publication. The snapshot agency failed to connect to publicati...more >>

Hi, i would need some help regarding SQL Replication between two servers, which are not in domain but in workgroup. Is it possible to setup such replication and how ? ...more >>

Can I setup a replication b/w an SQL 2005 Enterprise Edition and a SBS 2003 running SQL 2000 if both the databases are having compatabilty level of 80? SQL 2005 box is hosted and replication access is done via a VPN connection. Can i know how this is possible ? Any good documentation ? ...more >>

Hi, First time for me installing sql2005 in production. Question that i have is that should I continue using log shipping to standby server or I should use sql2005 replication? Thnakl ...more >>

Have transactional replication with queued updatable subscribers configured between 2 SqlServer 2000 machines and a push subscription running on the publisher ok. Now adding a new push subscription on the same 2000 publisher against a new 2005 subscriber. Transactions from the publisher are repl...more >>

If you never run the snapshot agent pass the first time then how come the distribution agent looks like it is delivering transactions? Thanks, Kristy ...more >>

The only difference I can see with the high latecy subscription is that it says: Delivering replicated transactions in the dbo.MSdistribution_history table (as well as Replication Moniter). There is nothing in the msrepl_errors for this subscription. Other subscriptions will always say someth...more >>

Does anyone know if it is possible to 1) detach a user DB that is published from an SQL 2000 SP4 server and attach it to an SQL 2000 SP3 server without planning to apply SP4 to the SP3 server? or 2) shut down the SP4 and SP3 servers and move the LUNS (with user datafiles) from the SP4 to SP...more >>

I was trying to test out how well my merge replication is working, so I created a new table on my main database and on my remote computer I created the same table but with data in it. I then tried to merge the two up and the data from my remote computer did not appear on the table on the main...more >>

If I have a ServerA and a ServerB, both currently have mostly similar data, but ServerA has some data that ServerB needs, and ServerB has some data that ServerA needs. If I am setting up merge replication, and I get to the point where it asks "Does MS SQL Server need to initialize the pub...more >>

I have set up transactional replication between two SQL Server 2000 boxes. I am replicating a table. On the publisher this table has a primary key, a clustered index, number of non clustered indexes and a check constraint. I want to replicate only the table structure and data, but none of the...more >>

I need to setup a duplicate web site and database as a failover. What is the best configuration for the database mirroring? The database servers are in physically different locations. Ideally, we want the running web site to use a certain instance of the database. For example each location ...more >>

I created a Publication and Subscription. Once LogReader detected transactions for replication. Distribution Agent status failed with error "Cound not find stored procedure 'sp_MSupd_users'". I cannot find any KB on this error, any suggestion? ...more >>

I have two machines. Call them \\MainDB \\TestDB On machine 1 i have a user named SQLServerAgent with Full Control Permissions to \\MainDB\logships and who is a sysadmin on that MainDB. On machine 2 I have a user named SQLServerAgent with Full Control Permissions to \\TestDB\logships and ...more >>