Hello, the main subject of my problem is, that i want to create a mobile database from a server database on the server. Sql server 2005 supports this, but it doesn't work. I created a publication for merge replication in my server database, but when i try to subscribe from my mobile data...more >>

I am new to SQL sever relication, and I have been asked to "clone" a production server, and then set it up for daily replication. I have used DTS to copy the existing data from the production server, one database at a time, and this has been successful except for one database. Our network / sy...more >>

Hi there. We have merge replications. Agent is run by domain admin and SA. I would like to moniter data change of the merge replication. I used profile but did not show the data change of the replication. Please share the wise Thanks nathan -- DBA...more >>

Hi, I am creating an automated way to add new tables to my publication. I have a script that creates the publication(s) and add the tables articles to the appropriate publication(s). What happens is that i want to be able to use the same SP to add new tables, so my ideal script would be a...more >>

Hello All, I have set up Log Shipping on my production server to ship the logs to a backup server. But the database in the backup server is always in the loading state. It have "read only" option set on its properties that way I can still run quires on the DB, but it always says (loading). ...more >>

Windows 2000 Server sp4, SQL Server 2000 sp3 I get the error below when attempting to delete a record from a table called Monitor directly from Enterprise Manager GUI. error: [Microsoft][ODBC SQL Server Driver][SQL Server][Invalid Object Name] 'tsvw_KJDKFAJDFKJAKLFDJKLAJDFKJASKFDJKAJDF' [Mic...more >>

When I try to configure using enterprise manager, at the last step, This error message raised.. Error 18483: Could not connect to server 'GKBT' because 'distributor_admin' is not defined as a remote login at the server What s the problem? Thank you ...more >>

When I try to do create a merge replication A -> B i get this error : "The subscription to publication 'KrowaPub2' is invalid. (Source: Merge Replication Provider (Agent); Error number: -2147201019) ---------------------------------------------------------------------------- ------------- Th...more >>

Hi, We have several SQL servers using transactional replication to a central server, they have all worked greate for a number of years but one day we noticed replication had failed on one of them with the error 'No such interface supported' on both the Snapshot and Log Reader agents. I have...more >>

Why can I make publications not to show this error. "You must rerun snapshot because current snapshot files are obsolete." I want them to start automatically and to generate the new snapshot file automatically. thnx for your time Martin ...more >>

Hello, I'm sending this message again since I don't have answer I have merge replication of 14 tables and for one specific table, everytime it's being updated in one server "SERVER1" I get the error in the conflict_mergename_tablename table that says: "The row was updated at 'SERVER1NAME.REPLN...more >>

HI , I know there must be silly mistake in below command , can u pls help me. I am trying this command at publisher database i.e. sp_dropsubscription @publication = 'testproc' , @article = 'test_repl' , @subscriber = 'backup' sp_droparticle @publication = 'testproc', @article = 'test_repl' ...more >>

Hi Freinds, My db is 10 GB in size, and want to get into a transactional replication The initial snapshot takes a long time to finish up. What will happen if during this initialization process, users work on pubisher db, insert, update delete record.... Thanks in advance, Pat ...more >>

I am getting a "The process could not bulk copy into table '[dbo].[ ... " error when attempting set up transactional replication between two SQL Server 2000 servers. The error occurs when copying the snapshot. The funny thing is that the specific error states there is a primary key violation. ...more >>

Hello, I am new to replication. And my boss has asked me to investigate the following. For handling optimistic concurrency which approach should we use... like should we add a timestamp column or should we check the values of all the columns. If we add timestamp column will it have any af...more >>

My ROWGUID columns are also my primary keys in many cases. I have some code that deletes and then reinserts a row that has changes instead of doing an UPDATE. As such, I re-use the same guid in the ROWGUID column. I have found that when I do this, the changes to the row do not make it back ...more >>

I set up transactional replication, then on the subscriber I changed the PK on a record, then went to the publisher and changed what would have been the corresponding record. So, what happened? * Nothing was changed on the subscriber. Good. * Replication continued to run. Good. .... bu...more >>

Hello Can You advise me some books about merge replication, with alternate sync partner and maybe republishing. Plus lots of T-Sql scripts with comment :) Best Regards Wojciech Znaniecki ...more >>

When I delete a merge push I got a message saying that it wasn't able to delete it at the subscriber. It recomended to execute the following instruction: sp_mergesubscription_cleanup @Publisher=NEPTUNO,@publisher_db=Diagonal,@Publication=Diagonal_Movimientos. Now I get this error message, and...more >>

Hello, I looked already very long to find out how can I uncheck a checked RadioButton?? regards mat...more >>

I'm using merge replication with sql2000 and sqlserverce. All is working well for now. My customer now wants my ppc app to utilize data from multiple databases. Is it possible for a single publication to contain data from multiple databases and if so will it merge correctly? This is probably ...more >>

Is it possible to read the list of publications on a database? What I'd like to do is give my PocketPC users the ability to choose which publication they wish to subscribe to on a particular day simply by making a selection from a listbox or a combo. ...more >>

I have some publications made. When I create push subscriptions there're no errors, but some of them appear like "Deactivated". The thing is that some of them work but some other doesn't, but none of them shows an error. I don't understand why the column "status" on the subscriptions grid shows a...more >>

After recovering a Backup of SQL Server Database the Replicaction LogReader Agent or Job Failed with error message The system cannot find the path specified The Backup and Restore was a complete bakcup of the server using Veritas software I'm using Windows 2000 Server Service Pack 4 and ...more >>

Hello, My Replication works fine when my PocketPc is connected via USB Cable with the Desktop. Do I have to implement any additional things that the Replication Mechanism also works with WLAN? (My PocketPc has WLAN). Is the oRpl.InternetUrl the decisive factor? - because at this url I have ...more >>

I had to failover our SQL 2000 EE Cluster yesterday and found the following errors in the SQL Log. "Failed to Obtain TransactionDispenserInterface" I have searched a bit and found that it appears that the MSDTC service is not running when the failover occurs. I looked into Cluster ma...more >>

I had to failover our SQL 2000 EE Cluster yesterday and found the following errors in the SQL Log. "Failed to Obtain TransactionDispenserInterface" I have searched a bit and found that it appears that the MSDTC service is not running when the failover occurs. I looked into Cluster manage...more >>

Using the 'SQL Server Enterprise Manager' before selecting 'push new subsription' a red X appears over the 'replicator monitor'. I noted the red cross appears over the folder 'merge agents'. If I look at the 'error details of the merge agent' it says 'The process could not drop one or more table...more >>

I have a script that adds a publication, adds articles, and creates a push subscription. Can I run all that succesfully in single-user mode? I ask this before trying it out ... J. ...more >>

I have 3 SQL servers in which I would like to manipulate the subscriptions and I am having some problems with the following code in 2 servers: Sample Code: 'Connect to server to get Distribution Subscriber information Set oServer = New SQLServer oServer.Connect Trim(sServer), s...more >>

At my workplace, we have merge replication established between three SQL Server 2000 (all with latest SP). One server is, of course, the publisher. The other two are simple subscribers. Recently we wanted to modify the subscription by adding three additional tables to the database and hav...more >>

I have what, hopefully, is a simple question. Do any of the methods of replication for SQL 2000 support the dropping and creating of a table and have it replicated to the remote system?...more >>

Hi , I am new in replication area . I have created a merge replication . The tables which is present in source table has identity key, after creating replication , I am able to add duplicate values in source as well as destinations table having same identity values . Secondly , When new tab...more >>

hello. I am wanting to publish the same table from the same db on the same publisher to two different wan subscribers. I want one of the publications to be extremly filtered down while the other one would be the entire table. Is this possible? I know in the past I have accidentally s...more >>

OK, yesterday I was asking about regular snapshots, and Hilary explained that the snapshot agent looks to see if one is needed and generates one as necessary. Well, I have another couple of questions about that, but let's pass on them for the moment and ask something else. When setting up re...more >>

We currently utilize the "data-centric" approach to our Smart Client application that we've developed with VS2003 and MSDE 2000. Our occasionally connected clients sync data via merge replication to another client machine designated as the primary database (Publisher). All computers run their ...more >>

I am getting the following errors while creating the replication. CREATE TABLE failed because column 'rowguid' in table 'ExactOptions' exceeds the maximum of 1024 columns. CREATE TABLE failed because column 'rowguid' in table 'ExactOptions' exceeds the maximum of 1024 columns. ...more >>

Hi, We are having a dedicated machine (with a fix IP) running SQl2000 and it is supposed to be the master database. And we are having 4 clients XP machine running MSDE (without fix IP), and we would like to have a merge replication to sync. data from / to the client / server. Coz data will b...more >>

I have a business requirement to start both merge/transactional replication after the successful completion of a certain process( not sure whether it will be a stored procedure or a batch job). How can I control the execution of replication this way? I am thinking of setting up a SQL Server ag...more >>

Our application makes extensive use of Identity fields as primary/foreign keys. One client decided to use merge replication between two sites. They brought in a consultant who set it up for them. The guy didn't know what identity fields were. He thought our application filled them in from some ...more >>

What does....Error at parameter 12 during datastream processing of parameterized command....mean?? How do I fix it? Larry... ...more >>

We have a medical application that records checks on patients. Around 100 sites using merge replication over adsl vpn A problem we are experiencing is data at the subscribers being overwritten with older values. Example: Patient check recorded at subscriber as 10:00 Patient check recor...more >>

Say you want to set up transactional replication from an OLTP server to a report server. On initiation, it does a snapshot (or we do it manually), then we replicate in almost-realtime. Just as an operational matter, what is the best practice here, do people schedule a new snapshot once a day/...more >>

I am continually having problems with the replication monitor reporting erronous errors. I have read in the past that this can be resolved by restarting SQL, but that does not solve my problem because SQL is restarted nightly on all SQL servers with the commands listed below..... REM Stop...more >>