Hi everyone, I disabled replication on my local sql server. I would assume = publication and subscription folder will be empty after I refresh = Enterprise Manager. however that's not the case. =20 Publication folder is empty after I disabled replication, but = subscription folder is not ...more >>

hi guys, I don't understand something, when I use domain account to do replication, it's in pending mode for snapshot agent, but once I use sa account to do replication, then it's in active mode. why can't I use domain account to create replication? ...more >>

Hi there Firstly, apologies for the multi-post - I could not decide which group would be best to post this to. I have a simple (I think) question. We are about to roll out our first SQL server based application. The application and run times are no problems - I'm pretty sure I know what ...more >>

Hi, In BOL there is reference only to sp_repladdcolumn and sp_repldropcolumn (add and drop), but nothing about altering a column, or have I missed it? I have to change the collation of a column (that belongs to a table that is transactionally replicated ) from sensitive to insensitive. Is the o...more >>

Hello, i set up an pull replication. The first client i setup replication over LAN and the second client i setup replication over RAS. Server: Windows Server 2003 SQL Server 2000 Client PCs: Windows XP Pull Replication over MS Syncmanager on demand Now my problem: At the firs...more >>

As I posted before. The company I'm working for is planning to develop a new system for our POS around the country. We want to find the best replication model between SQL Servers. The situation turns difficult for us since we won't have static IP's on each POS but dynamically IP's assigned by ...more >>

Hi, Is there any possible way of creating a snashot without reinitializing the entire replication? I need to create a job that creates a snapshot, because I have a new server to add, and my last snapshot is out-of-date since we've added a few columns to replication between that snapshot cre...more >>

Hi, I have set up a txn replication with the default subscription of 336 hours before it expires. the initial snapshots generated 78 articles. The replication has been going on quite successfully but over the past few 3 -4 days i did not check and yesterday , i realised that the snapshots wer...more >>

I am trying to setup a simple mirrored database. I have an SQL database on my local server called 'ABC'. It is behind my firewall and available to on my network. I have another database outside of my network at a co-location center that I want to mirror to (call it 'EFG'). I have made most ...more >>

I cannot get a pull merge replication to work. The distributor is Win2000 running SQL 2000. Subscribers are XP Pro running MSDE. Agent command: -Publisher [DistSVR] -PublisherDB [MyDB] -Publication [MyDB] -Subscriber [SubSVR] -SubscriberDB [MyDB] -SubscriptionType 1 -SubscriberSecurityMo...more >>

I know I can't do an alter table on a replicated table because it is being replicated. But, in my software, if I need to modify a table I do an alter table and add the new column. What is the easy way, via SQL script, to see if this machine is a distributor/publisher for replication, in which...more >>

Hello ErveryBody How to run mergeReplication agent using Vb.net.. i created Publisher,distributer and subscriber using mssql 2000 enterprise manager Wizard it's helpfull for me. thank you Sam...more >>

If I select "Continously-Provides minimal latency between when an actions occurs at the publisher and is propagated to the subscriber" for the agent schedule when pushing a new subscriber, the wizard throws the following exception: " SQL Server Enterprise Manager could not start the service 'SQ...more >>

Hi All, I need to update a table on a server from my PDA, so what I am doing is the following: I pull the table to the PDA via RDA Pull. Tracking is ON and the table has an autoincrement primary key as well. All I want to do is add to this table the data captured by my PDA (so I am not inte...more >>

The row was inserted at 'Subscriber Laptop' but could not be inserted at 'Publisher server'. INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK1'. The conflict occurred in database 'Tst', table 'Report', column 'ReportNo'. http://support.microsoft.com/default.aspx?scid=kb;en...more >>

We are migrating the entire sqlserver environment from Window2000 to Windows 2003 on different boxes with different NT servernames. I have installed the sqlserver instances and I have restored the publisher, distribution db on the primary side and the subscriber db on the replicated side. H...more >>

I try to push my publishers to subscriber, there is a error number:306 The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. (Source: NTASH02 (Data source); Error number: 306) the error appear after : applied script sp_AddDitEntryDsir...more >>

How do I prevent deletes occurring on a replicated table from being replicated to the subscriber? The subscriber will only receive Insert & Update DML... TIA, Chris...more >>

I have an anonymous pull subscription, and see it in Windows Synchronization Manager when logged into the administrator account that created the subscription. If I log off and back in as a non admin account I can not see the subscription. If I add the non admin account to the local admin group...more >>

...more >>

How to package the correct set of necessary assemblies along with the client to ensure that the software can function correctly while deploying replication implementation along with software. Is MS planning to provide a merge module or similar for the replication featureset?? what is the...more >>

Hi. In the company I work for, we are planning the development of a new sales system. We have many stores all around the country (and growing) and we want to adopt an adecuated replication model for bringing all information from stores to main facilities and backward. I have worked before wi...more >>

Hi all, When setting up a (merge) publication using the wizard, you can click the three-dotted button in the "specify articles" and then setup the identity range for publisher and subscribers. While this is an interesting option, I see that the default is not checked (yes, I have the ident...more >>

Hello Paul and Hilary, I have a requirement and very little time to do two way replication for a hand full number of tables between a SQL 7 box and a SQL2K box. I am using Hilary's book as my guide and feel very privileged to also have access to this news group with expert advice from Paul ...more >>

Hi All, Running SQL2000, SP4. Publisher and Distributor on same machine, 40+ subscribers. Merge replication. One of our technicians went to run the dynamic snapshot agent job for a specific host (we use filtering in our publication, so each computer has its own snapshot agent.) and it ...more >>

If you are using replication and need a rowguid, and you need a unique primary key for the table anyway, is there anything wrong with using the unique rowquid for the Primary Key? If not, what are the downfalls? Thanks, Steve...more >>

hello everybody when i create the subscribers . i got error . i try both account system account and this account ... but same error Subscriptions were created successfully at the following Subscribers: BOYD SQL Server Enterprise Manager could not start the service 'SQLSERVERAGENT' on...more >>

Dear all I have set a merge replication between servers say SERVER A (Publisher) and SERVER B (Subscriber to A) The agent runs every 2 minutes. I have set all identity columns with increment value by 2. SERVER A has all odd identity values and SERVER B has even. I have 2 more servers (ST...more >>

Hi. We have a SQL Server 2000 sp4 on a Windows 2003 Small Business that contains publisher and distribution databases. Also we have 2 MSDE sp4 running with push subscriptions with immediate updating. We are just learning how to do this better, because we are going to configure distrib...more >>

Drawing a blank.... How do I unmark a restored db as not being replicated & get rid of all = the replication objects in this db? Thanx!...more >>

Working with Merge Replication between SQL Server 2000 and SQL Server CE 2.0. I was doing some filtering on the Publication with "host_name()" function. I was comparing host_name() function with a nvarchar column, so all was working pretty well. In order to filter all appointments for a spe...more >>

Hello! I have this strange problem with my script that creates the replication of table. After some table creation and other stuff, I call stored procedure sp_addarticle with the following arguments: exec sp_addarticle @publication = 'my_pub_name', @article = @table_name, @source_ta...more >>

Error 14046: Could not drop article. A subscription exists on it. I get the above error when I try to drop a publication in SQL2k. I do not show any subscriptions for this publication anywhere. How can I find the subscription that is blocking me from dropping this publication?...more >>

In the SQL Server 2005 CTP installation I found out that it's possible to publish databases automatically to an oracle server. Will there also be a mechanism in the final product to do the same for IBMs DB2 server?...more >>