While creating a replication database i am facing the error No. 21082 "Database property 'IsRecursiveTriggersEnabled' has to be true for subscribing databases at updatable subscribers". Can anybody help me solve this problem. I have also tried setting the options of enable recursive trigger...more >>

I m trying to replicate data among the databases of local and web server, i found that using ftp we can do it, but i want to create a push subscription to the webserver(local server being my publisher as well as the distributor) since i cant create a pull subscription on to the web server ...more >>

Hi, not sure if this is the right news group but it deals with replication so.... here goes... I now have a sync job over the internet via VPN. The user double click the VPN connection, connects and run the sync job manually. I now want it to run automatically every night. How do I...more >>

hi when in intial push i am getting this error. but my sql is SP3a installed. what could be the reason, pl advise us. Jay....more >>

Hi, I need to setup replication for the following scenario. I could not configure it as I required. Please suggest me what am I doing wrong. System specification Windows Server + MSDE 2000 in all publishers and subscribers I am having one main server which is configured as a publisher...more >>

When I query databases which are subscribers to a publication, I never see the IsSubscribed giving a true value. IE select DatabaseProperty('vlm','issubscribed') always reports false. Is this a bug, doc bug, or do I not understand the meaning of "is subscribed"?...more >>

Hallo, ich habe ein Phänomen bei einer "Merge-Replikation" mit SQL2000. Das Aufsetzen der Replikation und die Replikation selbst funktioniert einwandfrei. Wenn ich nun im Anschluß über "rechte Maustatste-Eigenschaften" mir die Anzahl der Zeilen einer bestimmten Tabelle der Quell-DB anzeigen ...more >>

SQL 2000 SP3, Transact replication. One subscriber has a record that the other subscribers don't have. Can't delete it or add a new one, and get this error: "Updatable Subscriptions: Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the S...more >>

I am having a bit of trouble trying to figure out what, if anything, is wrong with my replication between two servers. Server ‘A’ has a DB which is replicated (Transactional) to Server ‘B’. On Server ‘A’ the database is 3.5Gb however on Server ‘B’ it’s 13.5Gb. I’ve checked the figures a few ...more >>

Hi I've recently implemented Merge replication on my network. Over the LAN it works fine. My SQL 2000 server is configured as both publisher and Distributor. I need to enable this replication via Dialup, however, which means going through the company firewall. I've opened port 1433 and 14...more >>

Hi, I have merge replication and its works fine for a long time. Some days ago I add new publication to the database with working publication. New one have one more table and based on existing publication. After creating new publication snapshot for new and old publication fails. I add o...more >>

Hi people, I'm new to SQL replication and currently trying to replicate one of my SQL2K servers. And I'm doing the testing on a test machine. The db that I'm replicating is abt 11GB, and I've one table which is abt 6GB. As this table has a lot of indexes but no primary key, to simply i...more >>

I am trying to dynamically construct a unioned query in T- SQL with a union? Would the following syntax work? Select a,b,c from ( select a,b,c from T1 where ... group by ... UNION select a,b,c from T2 where ... group by ... ) X I am getting an error saying there is incorrect synta...more >>

Hi, i configured the sql servers in transactional replication. but when i insert the second server which is subscriber to first one, it is giving error as sa login failed. advise me, thanks, Bob...more >>

My previous post had incorrect schema for subscriber, should be : CREATE TABLE [dbo].[TblRepl] ( [PK_ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL , [Col1] [char] (10) NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[TblRepl] ADD CONSTRAINT [PK_TblRepl] PRIMARY KEY CLUSTERED ...more >>

I have seen this error mentioned in the newsgroups, but I have not seen a definitive answer. I am doing uni directional transaction replication from a SQL2000 server to a SQL7 server. I am keeping the Identity and the "not for replication" properties on the subscriber. Snapshots and inserts...more >>

I have a product that I am running that I am trying to upgrade. I am running this product on SQL2000. When I run my script it give me the following error for a few tables; Server: Msg 4929, Level 16, State 2, Line 1 Cannot alter the table 'BillingRatesEffectiveDates' because it is bei...more >>

Hello... this is my 1st attempt at replication. The reason for the replication is Strictly to mirror a mission critical backend. In case the Server crashes, I want to be able to change the ip address on the machine with the subscription, and hopefully be up and running while the Server is bein...more >>

Microsoft Consumer this is the latest version of security update, the "October 2003, Cumulative Patch" update which resolves all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to ...more >>

How can i alter my publish table in SQL server enterprise manager. i don't want to do it through publish articles not by executing stored procedure. i want to do it by opening the design window. but it returns error that can not change table as it is used in replication....more >>

Dear All, Is a must to create snapshot after we change/alter an article (such as alter add/drop column in table) in publication? Because we have an experience that we create snapshot after change an article and then synchronize to subscriber, it took long time (about 30 hours for 1 GB)...more >>

HI, I am trying to drop tables from Merge replication and create a seperate Replication for the dropped tables. I Ran sp_dropmergearticles on the publisher for a list of selected tables. After this I performed a seperate replication for the dropped tables. But I get the below error "The proc...more >>

Hi Guys, For data archiving i will transfer old data to another table and for reporting purpose create a view of both tables. but for transaction HOW can i enforce primary keys as data will be in two tables. Thanks...more >>

What methods are used to detect/alert when network connections fail? Scenario: Central Publisher(SQL2000) connected over a WAN to Subscribers(MSDE) - use the alert tools to notify administrator? - when the connection is restored, replication will magically continue? Scenario:...more >>

We have a SQL Server 2000 Enterprise Edition database running in a Windows 2000 Advanced Server clustering configuration. We'd like to make a copy of the "production" database onto the failover server for use as a reporting database during non-failover times. We have the primary instance of ...more >>

Hi, We have a Snapshot Replication setup so that it will replicate a bunch of tables from production to a report server. However, it failed on one table with an error like "The process could not perform the bulk copy...". I have noticed that this table contains a ntext datatype field. ...more >>

Hi I have 4 sql databases on 4 different regions. I want to do replication as like the 4 serves should have the same data. i mean 1-2-3-4 . what type of replication will help me. Thanks, Jay....more >>

Hi What is going on under the hood when two dates at the publisher and subscriber are identical? I have a (table) article that has a composite pk of Guid column and Datetime column and in testing when I use the DATETIME [LaterWins] Conflict Resolver and the value is identical at both Publis...more >>

I need to set up replication. I've read lots of stuff about it and I know that it needs to be push transactional. The steps that I've found to follow seem pretty straight-forward, but I have a REALLY basic problem (which may not be appropriate for this forum): how do I set up the Server Agent t...more >>

Hi All After running an update on the database it took 7 hours to replicate this data, this was the done on the 28th September. I can accept this as normal. My question is, I have now had to add another subscriber, so yesterday I backed up one of the subscription databases and restored it to t...more >>

Dear all, Please help us on the snapshot bulk copy issue with a TEXT field. The snapshot agent was failed with below message: The process could not bulk copy into table '"Enclosure"' We have a big table about 170,000 records that needs to replicate to other sites. There is a TEXT field ...more >>

I have a replication, when i execute the synchronizing i receive the following error The process could not read file '\\STJINADESKTOP\f$\mssql\data\MSSQL\ReplData\unc\STJINADESKTOP_doctors_doct ors\20031001151619\doctors_1.sch' due to OS error 5. The step failed. Can somebody help me please ...more >>

My team currently uses merge replication to coordinate a database across two sites separated geographically. We now wish to add a third site to the replication process. We plan to copy all data in the tables at the third site into the Publishers corresponding tables. After this, the Pub...more >>

Greetings, I've configured my distributer, publisher, and subscriber, but when I try to create the publication, some tables have a key image (I assume that means they're locked) where the checkbox should be. Anybody tell me why? Thanks. Ryan...more >>

For a thrid party application, I need to place a sql server in basically a suspended state. I need all transactions that are occuring to complete, and while they are completing, and after they are complete, no new transactions are run. The idea is to get the server into a static state. ...more >>

I'd like to replicate manually a sql server to another server. It's ok for the databases with backup/restore. But I have a problem with the logins. How can I replicate logins from one server to a second server with the same rights ? Someone have the solution ?? Thanks...more >>

Microsoft User this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express. Install now to protect your computer from these vulnerabilities, the mos...more >>

Microsoft Consumer this is the latest version of security update, the "January 1998, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to mai...more >>

Microsoft User this is the latest version of security update, the "October 2003, Cumulative Patch" update which fixes all known security vulnerabilities affecting MS Internet Explorer, MS Outlook and MS Outlook Express as well as three newly discovered vulnerabilities. Install now to continu...more >>

I have problem with replication, thinking how to solve it. Two databases with identical structure, connected with merge replication. Each database must everyday import data from another extern databases - such databases also have identical structure, its extern system. Identical rows can be...more >>

I have a replication setup with push and pull, but when i run the pull at the subscriber i'am getting the following error : can not read file //computername/f$ ...... This is the default snapshot location. Can somebody help me please regards, Steven ...more >>

Dear all, I would kindly like to ask how Sync-with-Backup works. I know what effect it has, and where to use it but....how does it work? Does it affect the performance of the Server if set as fast as possible (with transactional Replication for example)? Does it require a separate server ...more >>

sql2k sp3 The tested scenario: Ive got several db's that all use the same distribution db. All the user db's and the distribution db have the sp_replicationdboption '<publicationdatabasename>', 'sync with backup', 'true' set on them. The distribution db and one of the replicated user db'...more >>

Hello. We have many clients (MSDE) defined to synchronize with our main SQL Server 2000. For performance issue, we had to defined 1 database per client so we can use the Transactional replication rather than the Merge one. This had created many Log Reader that need to run on the server. I...more >>