Hi, I read many interested things about the enhanced features of the SQL-SERVER 2005 replication. I want to make an test installation of the SQL-Server 2005. When I have problems, do you support SQL-Server 2005? Best regards Axel Lanser...more >>

I ran spBrowseMergeChanges from www.replicationanswers.com for one particualr table that I Know a lot has occured on. It shows a result set of 6,469,634 rows. BUT, the enterprise manager is showing "No Data needs to be merged". Help. This isn't the only table that has this problem. I looked at...more >>

I deleted tons of recors in one table on the publisher. I want to stop those from replicating (for the time being or forever - doesn't matter) since it is sucking all of the replication time. Is there a way to do that, if so, how??? Darin *** Sent via Developersdex http://www.developersde...more >>

Hi : i have two tables, parent table is customer, children table is customercontact and they link by customercode. fistly, i set join filter as customer.CustomerCode=CustomerContact.CustomerCode. then i set row filter in customer table with customer= HOST_NAME() ...more >>

Hi, Quick question, Can I use the 'Alter table mytable alter column' to change the Identity column to include the 'not for replication' clause? Or do I need to drop and recreated the table? thanks, ...more >>

Periodically, I get a these messages appearing from the System Log. These errors once started will always continue for the next few hours until the server is restarted. During then - software distributions seem to fail. (SystemLog) Event Type: Warning Event Source: EventSystem Event Cat...more >>

Hi, I am using Merge Replication and the subscriber is a pull subscriber. Some tables are filtered, in the publication properties, if I go to FILTER ROWS, then FILTER CLAUSE column, some tables are filtered like so depot_system_id = 'xxxxx-xxxxx-xxxxx-xxxxxx' where x makes up the guid. Th...more >>

Hi, I have a transactional replication as i mentioned earlier and has 4 publications. My subcriptions had been deacticvated since there was no syncrnisation diring the retention period. As a result i reinitialised the subscriptions for each of the publications. Then i ran the snapshot agent...more >>

Hi, Myself and a colleague have been charged with making two SQL servers (SQL Server 2000 STD) replicate in real time, this is to allow a helpdesk system to be updated in either the UK or South Africa. Unfortunately as the helpdesk system we use is not by our own design we have to use the s...more >>

I'm getting the following error when trying to set up replication between 2 servers (the error occurs on the master when I try to run some stored procs). Both servers are linked as "Remote Servers": Login failed for user 'xxxx'. Reason: Not associated with a trusted SQL Server connection. ...more >>

Hi, Our production site, I enabled snapshot replication, last night the distribution agent failed with error message: Detect nonlogged agent shutdown. I really don't know what that means; can someone help me to solve this problem? Regards, -Chen ...more >>

Hi, I've got the error in the Subject when I tried to delete and recreate manually a pull subscription to a publication. How can I delete defenitely the subscription from that database? Thank you....more >>

Hi, I'm getting a problem with updating a record in transaction replication that i was hoping someone might be able to help with. I have a test setup with transaction replication with immediate updating between two Sql 2000 servers version 8.00.818. The table is 187 columns with everyth...more >>

Hi All, I have selected merge replication because both servers are constantly updating information. We have continuous merge replication (push) and everything works pretty good. The problem is in some occassions the job stops saying that it can not enumerate the changes on the subscriber...more >>

The log reader has stopped on me a couple of times with the error "The step did not generate any output. The step failed" Does anyone know what might be causing this? Thanks. Peter Doyle...more >>

Hi : i have two tables product and productFlavour, which all have productcode in each table. so in the table filter. i put product.productCode = productFlavour.ProductCode. my question is that can i still add a row filter for productFlavour,( for example productFlavour.isDelete=1)....more >>

Hi, My log file on the publisher for the published database, doesnt seem to grow, its always around 1MB, teh log file settings are set to allow the file to grow incrementally and everything else seems normal. After some further investigations I came across an option that should apparently ...more >>

Can anyone direct me to resources to read about setting up "usual and customary" maintenance plans for SQL? ...more >>

After creating a snapshot job using sp_addpublication_snapshot how do I get the job_id? I want to be able to rename the job as well as change the owner through script after it is created but sp_update_job requires the old name or job id and sp_addpublication_snapshot doesn't return either. ...more >>

Hi, When i use the "sp_copysubscription" procedure, i am getting the following error. "Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line 64 The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription copy or it has not been synchronized.". My subscrip...more >>

I have written a custom conflict resolver as a stored procedure. When it attempts to return the results rowset, I get the following error: The Stored Procedure Resolver requires the stored procedure '[dbo].[sp_TicketInfoResolver]' to return a result set that matches the column definition of t...more >>

Hi I have a transactional replication set up with a simple recovery model. My logreader seems to be doing its job by inserting data into the Ms_repl_commands table. But apparantly when i refresh the current activity on the SQL enterprise manager it hangs. I have noticed I have got a huge am...more >>

Is it possible, after setup of replication, to drop/delete a table. the table is empty and not being used. I have read how to remove columns but don't find any information on an entire table. WB ...more >>

I have about 7-8 publications in my environment (Transactional Replication). What should be the strategy to check if all of these publications are working. Should I add dummy record to one table in each publication to see if the record makes it to Subscriber or not? Any advice? Thanks....more >>

I have two servers that I am connecting with Merge replication (SQL2k). SERVER1 is the publisher and pushes a subscription to SERVER2. After the snapshot is created, the Merge Agent runs but gets the following error: Procedure or function sp_MSaddinitialarticle has too many arguments spec...more >>

Hi, I have publisher and subscriber, publication is merge. When the subscriber synchs up to publisher, I sometimes see it had x amount of deletes, how can you tell what was deleted? Is theer a way? Thanks in advance Warren ...more >>

Win 2000 & SQL 2000 SP3 I have a publication that wants to be reinitialized (The subscription(s) have been marked inactive and must be reinitialized. NoSync subscriptions will need to be dropped and recreated.). When I created the push subscription, I did it NoSync, so I know I have to dro...more >>

Hi, I defined a publisher and a pushsubscriber with some articles. The articles were Tables, Views and user defined functions. The pushsubscriber was created with the sync_type=automatic. When I synchronisize the publisher with the subscriber, the merge-agent fails on the follwing view creati...more >>

I need to be able to shut down my replication agents with a sql command as I am preparing a script to ensure a graceful failover to our DR site. How can I turn off the agents via SQL? Thanks. ~lb p.s. I'm pretty sure Hilary will respond.... I got your book yesterday.... I recommend it to A...more >>

Hi there. We have just purchased a new server, which I am trying to set up replication to. I have no problems until I hit one database. I am having trouble when it hits the following SP CREATE PROCEDURE sp_pull_data_1 -- Get list of renewals for a date 'days' in the future -- Date: 12...more >>

When I try to start the agent (replication monitor->Agents -> log reader Agent - with red cross). show me this error : 22022 sqlserveragent error: request to run job svr-personal-origen-1 (from user personal\alioscha) refused because the job has been suspended. SO windows 2000. server 2000 s...more >>

Hi, When i use the "sp_copysubscription" procedure, i am getting the following error. "Server: Msg 21236, Level 16, State 1, Procedure sp_copysubscription, Line 64 The subscription(s) to Publisher 'CNS_SQL1' does not allow subscription copy or it has not been synchronized.". My subscrip...more >>

I deleted the Indexes from several tables. Should I force a re-run of the snapshot agent? ...more >>

Hi There, I have a situation here. I currently have a server that is acting as a publisher. I have a few laptops as subscribers. We have recently bought an upgraded server. I wish to move the SQL database on the new server but at the same time I do not wish to lose the publication and subs...more >>

I've always had a hard time getting my head around Push and Pull Subscriptions. Ive read that it really doesnt have a huge impact on a box, and that what really matters is where the Distributor is. That Push or Pull is more for Administrative type of stuff. Just not sure about this. I ju...more >>

Running SQL 2000 SP3. I am getting this message when I start the SQL Server Agent.... [298] SQLServer Error: 3908, Could not run BEGIN TRANSACTION in database 'msdb' because the database is in bypass recovery mode. [SQLSTATE 25000] (ConnIsLoginSysAdmin) How do I get the 'msdb' out of re...more >>

I'll first give the caveat that I've been away from this project for many weeks (but at least it is my own creation). Having said that, I'm not sure if this is a replication problem or exactly what I have on my hands here. When I submit an Insert to a particular table, I can submit as many In...more >>

Dear All We have developed an Order processing Application, We have Head Office and three branch offices located throught the country, Each brach office has its own SQL server installed , at the end of day we want to gather all branch offices data into our head office sql server , I have pl...more >>

Hi I am developing a smart client application. I have to push the client side data back to the server side and vise versa what would the most secure way of doing this -SQL SERVER MERGE Replication - Web Services ? Anyway else Could anybody help me out ...more >>

just wondering would it generates trigger for some tables when those tables doing merger replication. using sql server 2000 Cheers nick...more >>

Is am running SQL 2000 SP3 on a Win 2000 box. My msdb is marked suspet. I ran sp_resetstatus and restarted SQL and the dB is still suspect. I found an article that recommends.... One approach would be to drop & recreate the msdb databases (see instmsdb.sql and instserv.sql in the c:\mssq...more >>

Hello, I'm wondering what type of replication (if any) is best suited for a publishing database that has a tendency to change schemas rather often. I'm under the impression merge is best for me, but I'm not totally sure. I'm not talking huge changes... just things like adding columns, tables, ...more >>

I have a Db which is both a transactional subscriber and publisher. I need to move the .MDF and LDF files to another drive set. What is the best way to do this? Thanks. Sherpa ...more >>

Hello, I am wondering what I am doing wrong or if what I am seeing is normal behavior. I have manual log shipping in place (via SQL LiteSpeed). We have a replicated database log shipped to a DR server in another location. When I fail over to the DR site, I can still see the publications on ...more >>

Hi, Over the weekend I was taking advantage of system down time and made some changes to my merge replication database. The changes were all successful until this morning I get users who are getting duplicate key error messages. I have verified that the duplicate key is causing the error. ...more >>

When I run the following sp on the remote distributor it works fine. When I go to run it on the publisher I get the error message that is below as well. sp_adddistributor @distributor = 'MyDist', @heartbeat_interval = 30, @password = 'password' error: Server: Msg 18485, Level 14, State 1, P...more >>

Hi All, Could someone point me to a white paper/best practices on how to move/update data from test sql server to a production sql server? Both of the server have the same schema. I would like to know if there is a way to synchronize the two databases. Would SQL Server Replication be a goo...more >>

hi, we are doing mergereplication of 6 database in a same server. we updated nearly 2lacs record in 2 databases. But in only database only we got the message no data need to be merged in another one its still showing connecting to subscriber. please give me a solution as early as poss...more >>

I am trying to use a remote distributor and I think my settings are wrong for RPC and mapping. How should these be mapped so that the publisher can see the SQL Server Agent on the distributor? --Kristy ...more >>

Greetings: We have set up a test scenario in Sql Server 2000 using merge replication with: A primary synchronization server (Publisher A) An alternate synchronization partner (Publisher B) Two subscribers to both publishers (Subscriber Y and Subscriber Z) After some initial difficulties...more >>