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 >>

Hi All, How to drop a single article (TABLE) from merge replication keeping publication intact. Regards Javed Iqbal ...more >>

Hi all, I have a scenario where this error now pops up for the second time. In a nutshell: - SQL (SP4) server, approx. 100 tables and views. Currently 14 subscribers running MSDE. - Database was exported a long time ago from Access and still has various 'strange' ID's in it (huge numbers ...more >>