Hi All, How can I resolve conflict on an article but I have 2 columns that I want to take as higher wins, Dose the built in resolver can be use when I have more then 1 column? Should I write my Custom resolver? Is there are samples to write custom resolving procedure? Thank...more >>

Hello, Could someone please help on this: I have a subscriber S_1 push subscribing two publications from database db_1 on publisher P_1 and database db_2 on publisher P_2. And now I have a new server S_2, which will be replacing S_1 as the subscriber, and S_1 will be decommissioned after ...more >>

SQL 7.0 Transactional push replication. A couple of days ago we encountered an issue whereby transactional push replication failed reporting inconsistencies with the LSN number. To resolve this issue, someone had suggested that I drop and recreate this subscription. While this will work,...more >>

A recent test of an application we use against a copy of the SQL Server 2000 database at a remote site turned up some issues with lack of replication of table permissions and some table column settings. The Public SQL group has certain permissions to some tables on the production system. Thes...more >>

Last night I ran the MS03-031 update against two SQL Server 2000 SP3a servers that have been doing snapshot replication to a remote site for some time, without issues. After completing the update, replication failed on one, but not the other. The failure was "the replication agent is not regi...more >>

Hi, Working on sql server 2000. Today one of my snapshot replication job failed, when I tried to restart the snapshot agent, a error message returned: 'Cannot generate SSPI context (Source: servername (Data source); Error number: 0)' Is is mean that there is a security access issue...more >>

Hi all, I am looking for List of some simple basic question, which will be based on Windows Application Development Exam Elective Exam 70-229: (Designing and Implementing Databases with Microsoft SQL ServerT 2000 Enterprise Edition) If any one having the sample list please mail me. Than...more >>

I have a simple but so far un answerable question. How do I tell the replication engine that a particular transaction has been completed? It looks like sp_repldone is the way to fox the engine into moving on from a problem transaction but completing the remaining transactions. A bit mor...more >>

error: exclusive access could not be obtained because the database is in use.. this happens after we take a complete backup and do a whole new restore with undo log as read only. ...more >>

I am getting this error in replication "propertiesViolation of PRIMARY KEY constraint 'PK__@snapshot_seqnos__7C2624A9'. Cannot insert duplicate key in object '#7B320070'. please help me out... TIA Bob ...more >>

I have been trying to remove replication from a SQL2000 db with sp_removedbreplication 'TimeMatters5'. When I do it gives me an error message. Cannot drop the table 'tm5user.conflict_TimeMatters5_Tutor_webhist', because it does not exist in the system catalog. Shouldn't 'tm5user.confli...more >>

Hi, I need help on setting up immediate updating subscribers. This is my current setup: Server A - publisher and distributor Server B - subscriber I have transactional replication working and Server A is replicating changes to Server B. However when I try making changes on Server B, I...more >>

I'm trying to write an SP to restart failed/stopped local replication distribution jobs. After looking at Microsoft stored procedures, I believe I should look at the "job_state" return value from the xp_sqlagent_enum_jobs SP. However, the same SP also returns a "running" column, but MS's...more >>

Hi, We have a replicated database which has quite a complex DB model with a lot of related tables (the DB is for a content management system). When a user performs a delete operation on the publisher and it is run on the subscriber it use 100% CPU and really slows down the machine (because of...more >>

SQL 2000 I thought I read some where that the primary key field in transact replication should not be an Idenity Seed. Does any body know of this? Thanks, Don ...more >>

I ran a delete statement on a subscriber that appeared to run succesfull and querying for deleted rows returned 0 rows as expected. After quering for the data sets again the next day, the deleted rows returned. We use merge replication and I am new to replication. Please help....more >>

What would be the difference in doing merge replication between two servers or setting up a transactional replication on both servers (i.e. Server 1 publishes a table to Server 2 and Server 2 publishes the same table to Server 1)? Would this (transactional replication part) allow changes ...more >>

Hello can anyone help me why appear a blue arrow in replication monitor, even in the agents. Thakn u Fabricio ...more >>

SQL 2000 transact replication. I removed the subscribers, then the articles at the publisher. Then I was able to delete all tables from the subscribers. But, all tables at the publisher say they are "being used for replication". Can't modify, rename or delete them. Any help appreciated...more >>

Hi, The queued transactional replication (with updatable subscription) between 2 SQL Server2000 servers reported a lot of conflicts.The connection between the 2 servers is very slow, and the servers are most of the time disconnected. I am not sure if this caused the following anomalies: 1) Som...more >>

I'm trying to change the user used to start the SQLSERVER agent service, but it as well as most "log on as" service options are greyed out in the services control panel appelet. NT 4.0 patched up to date. SQL 2000 Enterprise patched up to date ...more >>

What do I have to do to setup retention based cleanup 1. Add -MetadataRetentionCleanup to the Merge agent job steps 2. Set retention period on the publication? I have a merge rep publisher and two subscribers (SQL2000 SP2). -MetadataRetentionCleanup is not specified and retention period ...more >>

Hi I have a pull subscription which I have copied. I can attach the .msf file to a new server using the enterprise manager without any problems. I want to script the attach process for MSDE. I am having no luck finding out how to do this. Please help Thanks ...more >>

I am looking for some advice on integrating data from separate SQL Server 2000 and Sybase databases running on separate servers (all on Windows) on the same LAN, and various file based systems. I have strong SQL Server experience, but no Sybase knowledge. The technologies that I am considerin...more >>

Hello, I have a SQL Server 2000 database where one of the tables should be "replicated" to a ORACLE database. I only need to take data inserted in the SQL Server database and insert the same data into a table on a Oracle database. How do I set this up? I am considering a On Insert-tri...more >>

How can i set automatic re-initialization in transactional replication in Mssql-200 server. right now it's manual. 1. Can anyone suggest the best way to overcome this problem? -- Posted via http://dbforums.com...more >>

Is it possible to setup merge replication with SQL7 being the publisher and SQL2000 being the subscriber? Thanks, Don ...more >>

Hi I am looking for which type of replication works in my dev environment. Here is the details. i am having 4 dev servers. I want the replication should be between all devs, i.e DEV1->DEV2->DEV3->DEV4->DEV1 That is every server acts like prublisher and subscriber. Please help in how sh...more >>

I made an transactional replication in my server "A" for one table called "tableA" but in the "destination table name" i put a different table name(not tableA) the new table is "table_serverA" , this replication send data to the Server "B" , in other server called "C" i create a transacti...more >>

This is my first production attempt at Transactional Replication, so please bear with me. My replication is setup, and appears to be working correctly. However the new data doesn't appear to be getting to the subscribers. If I check my adminlog table the most recent date and time is 9/11/20...more >>

Dear All, Is there a tutorial that anyone can point me to which how to create .dll for use with Extended Store Procedures ? Thanks J...more >>

We've 3 sites with SQL server 7.0. We're writing a VFP 7 accounting app that requires data from all 3 sites. There will be many more apps for other purposes soon. Which is better, using web services to obtain the data or to replicate the SQL servers? I have the impression that web services i...more >>

Hi all I have two servers (A - sql7.0 on NT4 & B - sql200 on W2000 server). A server will replicated data to B server and both administrators and sa have the same password. Now I want to change one server's administrator and sa password. Is it possible? Regards Shek ...more >>

Hi all, Can you suggest me such a scenario to "live backup" from a site to another site using WAN without any probability to lose the data even a record ? Or, is there in SQLServer2K such utility that similar to sybase's utility called "dbbackup" with "-l" parameter, which doing "live backup...more >>

HI, i have configured 6 merge replication with pull=20 subscriptions each one. The difference between them are=20 the filters.=20 In one of them an article (table) do not send all the data=20 to the subscriber and the other 5 send all the data fine.=20 For example, this table doesn=B4t have f...more >>

"Transaction cannot start while in firehose mode" I have set up replication between my development machine and our server. I am using the Northwind database as a sample and only am replicating the Customer table. when I click on tables and then Customer and select "return all rows", I then...more >>

I am doing a research paper on database replication. Where I am comparing Microsofts replication and Oracle's repliction. I need to know where I can recieve info on Microsofts repliction process and what is uses. thanks very much...more >>

can you give me the exact syntax to run this to fix user sids after a database copy to a new server....more >>

Hello All! table between primary & replicate is out of sync and we use DTS to sync it up. But after the DTS completed and we ran the article validation for it but the validation failed. We also run the checksum manually and it does show difference values. Any ideas? Notes: replication ...more >>

Hi, I have set a Transactional Replication : -I have 2 tables, T1 with Col1, Col2 and Col3 and T2 with ColA, COlB and ColX. -Col3 on T1 references ColA on T2 with a foreign key -Col3 is NOT replicated (using filter column) I got this error when initializing snapshot on subscibe...more >>

I had a server setup for merge replication and the replication was working wonderfully. I ran into a situation where I had to give up that hardware for other requirements. I create another box using the same name and am now having an issue removing the Push Subscriptions that mysteriously appea...more >>

Hello, In this kind of scenario: I have two computers, one laptop, one desktop. Initially, I installed the same application onto each of them with the same data. Then I use them separately and input different data. Each day of two, I need to merge the data so that both of my laptop and desk...more >>

I was trying to run the following SQL Server 2000 SP3 query on a Windows 2000 SP2 box: INSERT INTO StatusHistory SELECT Component_ID AS StatusHistory_ParentID, 'I' AS StatusHistory_Type, Component_Status AS StatusHistory_StatusCode, getdate() AS StatusHistory_Added, 572 AS StatusHistory_AddedBy...more >>

In transactional replication how can I force the snapshot agent to create a snapshot every night? I scheduled the agent to create snapshot but I get the message that "snapshot was not created because no subscriber need it" Data has been changed considerably which forces me to re- create s...more >>

I would like to obtain SQL Server 2000 transaction replication installation procedures. I would like this documentation to have an explanation of each step. Thank You, Mickey mautry@ev1.net ...more >>

SQL 7.0 Transactional Push Replication Hello... we have trans. repl. estb. between our PROD and DRP servers. During a failed application implementation this morning, we had to fallback by restoring the DBs on both servers (backups were taken separately on these servers at the same time). ...more >>

Hi All, I am running SQL 2000 Publishers, Distributor and Subscribers using Merge Replication..all SP2 ( All on Win2000 Server SP 3 ) When I run profiler on one of my subscribers I see that it runs the following procedure. =================== declare @P1 int set @P1=7151646 exec sp_MSchec...more >>

It is possible to delete a table (on replication) without stop the merge replication Thanks ...more >>

We use SQL Merge Replication for nearly 2 years. The application is designed to avoid data-conflicts: The clients have disjunct data (horizontal filtering), and the server only changes columns which are read-only for the client (and the other way around). So there were no conflicts in the last 2 ...more >>

I am creating a small .NET app that will be disributed to various clients. The client app will have an MSDE DB and replicate back to the central SQL Server. What all is entailed in setting up replication and the clients specifically. And what are the pitfalls I need to look out for? ...more >>

Here is two machines A(send data) and B(receive data) using PSTN and merge replication to transfer data.The data in machine A have been tranfered to machine B more than one time.Now machine A is damaged and the system including OS,SQL Server are reinstalled ,also the replication is reconfiged.No...more >>

In my SQL server, If I get error during setting distributor and publisher, then I can't set it again. e.g. I get following error during setting distributor and publisher Error message as following SQL Server Enterprise Manager could not configure 'dbsSourseDB' as the Distributor for 'dbsSourc...more >>

Hello, and thanks for any help. I have a SQL 2k SP3 merge replication is being used. The sql server is running on a win2k adv. serv SP3. can I delete the contens from a conflict Table or is in the background working a organisation -- Elzer Helmut Fujitsu Siemens Computer ...more >>

Hi, I have transactional replication running between 2 SQL 7 (sp3) NT 4 (sp6a) servers. Every night, shortly after 2 am, the pull subscription fails with a S1T00 - Timeout Expired error (with no details). There is never a timeout problem throughout the day, even when there are over 100000 ...more >>

I try to make a replication on my SQL Server2000 SP3 on Windows2000. I want to replicate 8 tables from Server1 to Server2. I found that 6 tables is work fine, however only 2 table that have an error that show below. How can I correct it? The process could not deliver the snap...more >>

Hi All I have 3 servers involved in replication (1 publisher, 1 distributor and 1 subscriber). The publisehr is creating a transactional artical and the subscriber performs a pull. The 3 servers are not on a domain but I have all the usernames and passwords synched up. When I try to r...more >>

I have configure a server as a distributor and publisher but it shows following error. I set it for transaction replication. Error message as following SQL Server Enterprise Manager could not configure 'dbsSourseDB' as the Distributor for 'dbsSourceDB'. Error 18383: Could not connect t...more >>

Can someone help. I am getting this error and this is the scenario I have one OLTP database and another DATAWAREHOUSE database residing on two different server. I have a procedure that runs to sync up data between these two databases. When the procedure run it fails on a statement which is ...more >>

I have noticed that there are records missing on my replicas that exist on the publisher. I have a SQL Server 2000 DB (win2k) with merge replication on several MSDE replicas (win2k and XP) using pull subscriptions. Nearly all tables are identical except for a some special tables I have...more >>

Greetings, I would like to coalesce the data from a number of "satelite" databases to a centralized database via replication. Some of those satelite databases use MSDE and others SQL Server Standard/Enterprise edition. All databases share the same schema and updates/inserts/deletes can only...more >>

I noticed that the table priviledges are blank on the subscriber machine after snapshot replication. How do I keep priveys?...more >>

We recently upgrade MSDE 2000 SP2 to SP3, with verbose logging, everything doing fine, at and of log file is: "Action ended 17:43:15: INSTALL. Return value 1. === Logging stopped: 28.07.03 17:43:15 === MSI (c) (60:73): Product: Microsoft SQL Server Desktop Engine -- Installation operation co...more >>

I'm using Sql Server 2000 with transactional replication. The subscription is an updatable subscription. The problem: Tables have a column msrepl_tran_version added with a datatype of uniqueidentifier. That column is defined as not null and also has a default of newid(). When I attempt...more >>

I managed to make sql work on ssl though another problem is bugging us. We use Snapshot replication and when I try to run the snapshot on the local SQL server the snapshot is never finished. The error is "The process could not bulk copy out of table '[dbo].[syncobj_0x3931303746443643]'." Error...more >>

Hello, I am trying to create a script that adds a new table to a transactional publication. The New table already exists in the database. Below is the script I am using. The script adds the new table to the publication, however it will not replicate the data to the subscriber. Can anyone ...more >>

Background: 1) SQL 2K SP 3 running on Win2K Servers 2) Original Snapshot Created via DTS Export from Publisher to Subscriber 3) Subscriber is 'primed' via script for removal of certain defaults, identity columns etc. The problem. I have certain tables that have Identity-Insert OFF on...more >>

Hi, There are lots of replication jobs running with no job history recorded, or the most with only current day's running history recorded. Was someone keep clearing the job histories or I have to turn the option on somehow to record job history? Many thanks. JJ...more >>