I have created a dynamic snapshot (a bunch of bcp files etc) and I am now wanting to know how I can apply this to my mobile subscriber. I am starting to wonder if I can even apply a dynamic snapshot to a device... Is it possible? Which classes would be responsible for this? Been looking aroun...more >>

Hi, We have a master database which I want to replicate/refresh just a few columns of one table to another database table on regular basis throughout the day to keep it updated. Is there a DTS package/task made specifically to refresh data in this way or do I have to write a procedure th...more >>

Hi, I'm desperate for some help on replication. I'm trying to replicate from one server to another and am having major difficulties. I've set up a snapshot agent, a push subscription and a distribution agent. However, I cannot get anything to start. I've tried to manually start the snapsho...more >>

Hi, I've stablished a replication between servers without any associated task. I wish to enable the user to make replications from inside an application at will. I'm tryint to find if there is a Transact SQL command, or a stored procedure that helps me do so. What other way I could achieve my ...more >>

Anyone here know anything about Microsoft Webstore ? ...more >>

Hi everyone, I'm running Trans. replication on sql 2k sp3, with the distrib db on a separate server and one pub server and one sub server. I'm trying to change the Log reader agent so it doesn't log into the publisher with the sa login and can't find a command or gui option to make the chang...more >>

Dear All, We are currently using Transactional Replication for a Warm Standby. We needed to perform a restore of out Publication Database last night and now we are getting the error :- DATE/TIME: 07/04/2005 09:50:29 DESCRIPTION: Error: 14151, Severity: 18, State: 1 Replication-Replication...more >>

Hello there I have database with hand picture (use for replication) And i need to delete it How can i do this? -- øåòé âåìãäîø ù.î. òúéã äðãñú úåëðä roy@atidsm.co.il èì: 03-5611606 ôìà' 050-7709399 ...more >>

If anyone can help me out with this. Trying to post a little more information about my problem. Keep getting: "Invalid working directory '0'" cmd.CommandText = "sp_adddistpublisher" cmd.CommandType = adCmdStoredProc cmd.Parameters.Append cmd.CreateParameter("@publisher", adVarChar, adPara...more >>

Hi, I have a problem with replication now. I changed the articles property on publications to replicate not only tables but also views and functions. Then on the failover server which is the subscriber, the replication job failed with below msg: ' invalide object name 'xxx', unable to re...more >>

can trigger be created on table sysdatabases in master dbs -- Message posted via http://www.sqlmonster.com...more >>

can a trigger created on sysusers , systypes.... -- Message posted via http://www.sqlmonster.com...more >>

I have been using merge replication for several years now in a publisher re-publisher configuration to give us geographical redundancy between the East and West coast. We are active active (take traffic at both locations) and use one-way pull subscriptions to our warehouse servers to facilita...more >>

All, I have been pulled int a project with urgency where a RAID5 set lost 2 disks. the server is gone and was not being backed up, it was a ( QA and Test ) dedicated distributor. I need to rebuild replication and have the scripts to do so. the problem i am encountering is that i cannot dr...more >>

Hello. We're running SQL Server 2000. I've created a transactional publication with queued updating at server "DATASERVER1" . When I attempt to push a subscription I receive an error in the Distribution Agent, as follows: Server 'DATASERVER1' is not configured for DATA ACCESS ...more >>

Hi, How can we add additional article (table) to a already merge replicated database. Pls give me a solution. Thanks, Herbert...more >>

Hi all, I am not sure if this question has a one line answer or I have to read an entire book on the subject. Here is my problem... I am developing VB ..NET based web app with MS SQL Server 2000 as backend. The beta version of the system is already in use from the main server. Meanwhile I keep...more >>

Hello I'm trynig to set a Alternate sync Partner in my Merge replication. I modify SQL Agent job step from : "-Publisher [PublisherA] -PublisherDB [Alt1] -Publication [DemoPublication] -Subscriber [Subsc1] -SubscriberDB [Alt1] -Distributor [PublisherA] -DistributorSecurityMode 1 -Continuous|...more >>

Can you have SQL with a online disk array, two servers, each mounting the same database and then NLBed between the two? So here are the questions: Can you have SQL 2000 open a database file accross a network share? Can two SQL 2000 severs open the same database file accross a network share ...more >>

I'm setting up trasactional replication and am encountering an error I've never seen before... On certain articles I receive a "CANNOT USE EMPTY OBJECT OR COLUMN NAMES" error. What exactly is that? I've been looking through the groups and can't seem to fins anything on this. Any help ...more >>

We migrated all of our sql server databases to a new OS (with the same host name). I restored master and restored all user databases so they are virtually identical. Three of these databases were being replicated. The distribution database was also on this server and also restored from backup. A...more >>

I already have Merge replication started between 2 machines and now I want to add a field to a table that is being used by replication. How can I go about doing this? Is there a stored procedure to do this? Thanks in advance, Jim...more >>

Hi, more or less once a day I receive this message from the merge replication, because is continuous suddenly stops. I try to put an extra step on the job to restart it but is ignored. Any clues why my step is ignored or why this problem is happening? cheers , Error: The process could no...more >>

Hi, Currently we are merge replicating more than 20 databases , One server is at our end other one is far away. we are having our end Server as Subscriber as other one as Publisher. During each replication first we set up the Publisher at other end and after the snapshot is over we ...more >>

Hi, I would like to know what encryption system uses by default SQL Server 2000 SP3 in order to transfer information between a publisher and suscriptor server in a merge replication process? Thanks ...more >>

I want to stop replicating any data changes to a table that has been selected as a published article. I do not want to drop the current subscription that I have. Can I just delete the system triggers for replication on the published table ? Thanks....more >>

I just created a new publication and subscription... And was in the middle of the synchronization when I dropped the publication.... I am now receiving a 'Could not find stored procedure 'sp_MSins_tablename'' for all of the agents replicating to this server/db. The error code is 2812. Anyone ...more >>

I'm looking for information about SQL2005's new featured called "Database Mirroring". What do you know about it? How does it compare to existing SQL2000 clustering/replication services? Will be only available to cluster servers? (I mean... shared devices, mscs, etc). Thanks ...more >>

Buenas, consulta sencilla (creo). Configuración: 1 servidor MSSQL. 2 instancias (A y B) 1 base de datos en cada instacia. (BA y BB) Quiero que si dan de alta un registro en la Tabla X, de la base BA (instancia A), automáticamente de de alta un registro en la base BB (instancia B), tabla Y (...more >>

Hello, I've setup transaction replication between two SQL servers and now I've added a column in a table in the published database. How do I replciate schema changes to the subscriber? Thanks ...more >>

Hi, Our JDEdwards production server has 10 snapshot replication setup, every week, JDE administrator ask me to drop some databases replication after few days re-create replication. So I saw snapshot and distribution agent number increase every time while I re-create them. For example: DEV...more >>

I am replicating a db from one server to another yet the source db is 20GB larger than the destination db. The two databases contain the same amount of tables 515. Does anyone have an idea why the source db would be 20GB larger than the destination db though they contain the same amount of ta...more >>

Hi, Currently we are doing mergereplication for more than 20 databases. When i set a publication for a new database i got a error message 1205 error (Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rer...more >>

Hi, I have set a transactional replication set up. Over the weekend the transaction log of the distribution database went as high as a 100 GB which is when it ran out of disk space and everthing went down. I ran sp_who2 and sp_who to check the blocks and i had a quite a few spids blocking o...more >>

Hi, how can I configure a replication merge with two database which have different table name? For example: Database 1: MYTABEL Databese 2: CUSTOMER Is it possible to create a replication merge between these two table, althaugh they have different name?? Thank you...more >>

i have a 6gb production db that may grow to 60gb. it is updated throughout the day via user transactions and collects information from datafeeds. i'd like to have a read-only copy of this db on a separate machine for the following reasons: 1) use it as a failover production db in case th...more >>

Hi ALL, Greetings I have set up Transactional Replication for my database, the distribution agent stated and copied all the data in to subscriber, but its is giving me error to copy the data again in to table, because the data already in the table. it is giving me error that unable to load ...more >>

Hi i am Oscar, I have a problem with database Subscriber. I've created this database with 2 datafile (*.mdf). the first datafile has static size and second datafile is define with unrestrictec file growth option . the replication have been worked all time, until the disc has fulled. How is po...more >>

While trying to set up remote distribution on server PUBLISHER_NAME, I get the above error when trying to specify the remote distributor. (Error 21776: PUBLISHER_NAME not found in DistributionPublishers collection on DISTRIBUTOR_NAME) However, I have set up distribution on DISTRIBUTOR_NAME, ...more >>

Any sql 2005 web synchronization pioneers out there? I have a problem when configure the sql 2005 web sychronization. I went through the configure web synchronization wizard. When it runs, it should do the following things. 1. Create the virtual directory 2. copy the ISAPI DLL 3. Enable w...more >>

Hi, We are merge replication more than 20 databases . Currently we added one new column to a table so it will be added only in last, and now only in this table the rowguid is not the last column. I want to know because of this is there is any problem in replication. Plea...more >>

Hi, Just to refresh I have a transactional replication running with a Publisher and one subscriber. The distributor is on the subscriber. I have got 4 publication and hence 4 distribution agents. all are running continuously. I just activated my subscriptions as my synchronisation was inac...more >>