Hi, I have used merge replication for SQL Server DBs before but not transactional replication. We have a DB with an existing application attached and I know that merge replication changes the DB and may break the app (otherwise I would use it). I assume that transactional replication does n...more >>

Posting to groups again.. Can someone give me a list of outside vendors that help support High Availability of SQL across geographically dispersed locations. I know Veritas, NSI, EMC have some solutions that eliminate the shared disk storage limitation of clustering.. Thanks.Using SQL 2000 ...more >>

I am trying to establish transactional replication between a SQL Server DB and an Access database. I keep getting the following error: SQL Server Enterprise Manager encountered errors creating push subscriptions for the following Subscribers: ACCESS1: Error 21060: Could not subscribe b...more >>

Hi All, I am trying to set up log shipping between SQL servers on two different networks (diff forests) with a two way trust relationship. Problem is that I can't see the remote SQL server in the destination server drop down list (I can see local SQL servers). The SQL agents on both mac...more >>

I am running windows 2003 /sql 2000 on the subscriber and win2k/sql2000 on the publisher. I have verified connectivity by ping and being able to register on the EM. I can also see the published articles when configuring a PULL subscription. However, when I do a push from the Publisher, ...more >>

Hi. I need to replicate a dynamic DB. It's dynamic in the sense, that the structure gets altered (column types, new tables, indexes and so forth). I've been suggested to use stored procedures like sp_repladdcolumn and sp_repldropcolumn (thanks Paul), but the manual intervention in the repl...more >>

Hello. According to BOL: "With snapshot replication or transactional replication, replicated data is by default read only; however, you have the ability to modify replicated data at the Subscriber by using updateable subscriptions. If you need to modify data at the Subscriber using snapshot...more >>

Hello. I'm trying to create a Push subscription from ServerA to ServerB and am getting the above message. I am using Enterprise Manager to do this. ServerB already subscribes to a publication from ServerC. I noticed that the error occurs on the first step of the "Completing the Push Subsc...more >>

Hello, During the process of replication from SQL Server to Oracle i get the error "The process could not allocate memory" and the last command executed is SELECT * FROM Table WHERE 0 = 1. Thank's in advance. ...more >>

Hi, Is it possible to replicate some field from multiple tables (as a result of select query with joins) at source to a single table at target ??? For example i have two tables at source 'source_table1' and 'source_table2' and one table at target namely 'target_table'. Now i want Field1 from '...more >>

Hi, im doing a pull subscription i have already done push subscription successfully first i made publication on my server whic is publisher then i pull that publication from another server connected to network and subscriber of my server. when i finished the pull subscription on subscrib...more >>

Hi I need information about how to implement replication programmitically on Sql Server(not using Wizard). Please help me. Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi I have a subscription which has a table and some rows which I cannot delete - they don't have a rowguid value set for them - when I try and delete I get a message about 'cannot insert a null value into column 'guid'. How do I tidy tihss up ? thanks ...more >>

Ive got my transactional replication all setup between 2 SQL Servers.. A table from Source A to Dest B has filters defined within a publication ... i.e select * from tableA where id in (1,5,10) Now I want to add another id in there in that filtered clause and not disturb the existing repli...more >>

Hi, Is it possible to replicate structural changes? I've been reading the replication docs, and it looks to me that this is only possible using snapshot replication (ie. not on the fly). Any products that can do better replication (all additions/changes to all db objects for a given db...more >>

I understand that there is a limitation in windows for compressing 2gb +. I am trying to create an msf by "copying a subscription". As an alternative method I have tried to copy the subscription database using the "copy database" wizard it gives me an error that is supposedly suppost to be a p...more >>

Hello, The SQL Server manual states you need special handling when you have a user trigger (at publisher only in my config) and immediate updating: "If both the user-defined trigger and the immediate updating trigger apply an update to the same row and you have not included a subroutine ...more >>

Hi; We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber are able to retrieve the subscription and replication. The error message on the failing subscriber is: " The schema script 'c:\myftp\ftp\FTPSERVER_ROYAL_ROYAL\200407 13093534\DocumentType_1.sch' could not be pro...more >>

If I push a new subscription to an existing target database, and I choose or check the box to include schema and data, will replication first delete or empty tables at the target before pushing a new? I did this, that is to push the subscription and checked the box to send schema and data and ...more >>

I am the middle man here, but I need some clarification please. A man I know runs a SQL 7.0 Server online for his clients. He has never used Replication before but is willing to go through the steps with me in setting it up. I also have SQL 2000 (using small business server 2003) that houses...more >>

Hello, I have a server with SQL Server 2000 Enterprise Edition that used until now and is beginning to have too many rows in the tables. Many of those rows are only used for statistics. I thought to pass the historical data to another server where it would consult the data. Thus the f...more >>

We need to set up transactional replication with transformation of data. What I mean is when data is inserted into subscribers, I need to insert data into custom table using some manipulation of data. What is the best spot to put this code?? Does MS provide a slot to dump some sort of tran...more >>

How to stop an agent after replcication is finished and erased. agent is responding jobID.... thx sinc --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching....more >>

Hope to get a lil info on the settings for this scenario... i got Table A that sits on different branches, and the data it contains should be merged with Table A in the HQ. So I've set this to use the Merge replication. So to ensure all branches have the same data in Table A, do i have to ens...more >>

Hello... I have been struggling with a Transactional Replication issue for a couple of weeks and I still cannot get this work. We have a Sql 2000 server (it is on Windows 2003 server) that is setup as publisher and distributor for a single transactional publication. The end result we'd like to ...more >>

Hi, Can someone point me to where I can find a copy of Hilary's replication celanup script? Thanks, Andrew...more >>

Hi All, Can someone tell me what a value of 512 means in the replinfo column of the sysobject table? I know that 0 means no replication and 128 means replicated but have no idea what 512 means. We have recently removed replication however we are still struggling with what may be the remnan...more >>

Does anyone has TSQL Script that can enable/disable replication set up. We constatntly make changes in our publications and that publication needs to be distributed in 14 other databases. It is really pain in the neck to disable the publication and re-enable it then push to all 14 data...more >>

If I make a database-structure change on the Publisher, will the structure change replicate to the Subscriber (and update the structure there) ? When pushing a new subscription, the wizard prompts if you would like to push schema and data. Does 'schema' mean ... the database structure? Than...more >>

Hello, I've generated a Snapshot which has been applied. The log reader agent is happy. But the third agent keeps saying The process is running and is waiting for a response from one of the backend processes. The log reader is working but it's not applying what it's reading because the n...more >>

hey ppl, i have this scenario.. ive got data stored in several branches in a MS access database. I want this data to be synchronized with SQL server in the HQ.. Whats the best approach of doing this ? can this be done by the system itself ? or is it a programming thing where code has to be wr...more >>

After changing the owner on all my tables it seems ALL columns lost there 'default values' if they had any....?? booksonline warn that all permissions will need to be reapplied but it did say anything about default values?? 1) I dropped existing merge replication subscribers and deleted the pu...more >>

I think I have seen this question posted before, and I apologize if I am = being redundant. On a test server I 'refresh' the data in a database by restoring it from = a production database. The test database that I am refreshing = replicates to another database on the same server. What is th...more >>

i verified that the server settings and authentication is the same for both servers/ i am trying to configure a windows 2003 server running sql server 2000 to be a subscriber to a publisher runnign win2k and sql 2000. when I try to register the server, i get access denied. any thoughts?...more >>

I have a question, about stored procedures. When i will do a replication from Sql Server to Oracle, what will happed with Stored Procedures, wil they replicate to?(Along with tables and data) ...more >>

Hello, I have a question about stored procedures in Sql Server, when i will do replication from Sql Server to Oracle, what will happen with stored procedures, will they be replicated to along with tables and data? Thank's in advance. Urko --- Posted using Wimdows.net NntpNews Component ...more >>

Hi; We have mulitple clients (subscribers) with MSDE SP3. All but one subsriber are able to retrieve the subscription and replication. The error message on the failing subscriber is "The computer is disconnected from the network". The computer runs XP Pro like most of the others and is connect...more >>

should I delete rowguid columns that were left in tables from a previous merge publication before re-creating the merge publication agian? The columns were created automatically during the initial merge publication creation... can I leave them and just recreate the publication? they all have dat...more >>

I have seen conflicting info on this one: Do I need to enable cross database ownership chaining on databases that participate in Merge replication (publishers and subscribers)? I have seen info pointing to maybe yes, maybe no... anyone have comments on this? ...more >>

Hello, I was wondering if there are any rules of thumb in determining whether or not to use push vs pull subscriptions? Any help would be greatly appreciated! Thanks in advance...more >>

I recieve the following error at the end of the script output: ----------------------- Server: Msg 156, Level 15, State 1, Procedure sysextendedarticlesview, Line 12 Incorrect syntax near the keyword 'if'. Server: Msg 208, Level 16, State 1, Procedure sp_droppublication, Line 45 Invalid obje...more >>

I have 7 databases in a replication to another server. All have the same settings, but are just different databases. On 3 of the databases the replication has failed with the message: "The process could not connect to Distributor 'SERVER'. SQL Server does not exis" The other 4 databases, w...more >>

Hi. We have replication setup from a sql server 200 database to a sybase database on Solaris. Every now and then, the sql server replication process will run into a deadlock with other processes on the sybase side and be chosen as the rollback victim. The rollback causes the entire replication t...more >>

Hello, I want to do a replacation of DB from SQL Server to Oracle Database 10g. Can anyone please help ? Some links or suggestions would be fine ? Thank's in advance. Urko --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our n...more >>

I'm running a clustered distributor on SQL 2000 sp3a. When I stop the publisher that runs in the same cluster (diffrent SQL server) the Queue reader first logs "ODBC Error:SQL Server does not exist or access denied." (It's dead) then it says "Unable to connect to publisher" and finaly it s...more >>

Dear anyone I have problem with Web Assistance in SQL 2000 to removing/dropping. Thanks for All...more >>

Hi, I have established a LogShipping plan with Secondary Server DB set as Standby, 15 minutes interval of Backup Log, Load and Restore. Questions: (1) Inside Log Shipping History, it seems that the Copy will always copy NEWER Log (in my case, 15 minutes later, eg. 1815), and Load will al...more >>

hi, I am working on sql server 2000 replication. I have an existing publication from server1 to server2 which has 6 tables in the publication. Now I want to add two more tables into this publication. How can I do it without have to re-initialize it? is it always better to re-initi...more >>

Anyone know of third party tools that would do the same thing? Maybe without alter replicated tables restriction? TIA, ChrisR...more >>

I was informed about an issue with merge replication on sql server 2000 sp3 and sp3a. This issue is that if your replicated tables are not owned by 'dbo' then you will have a variety of problems. (thank you Kestutis Adomavicius). I have been trying to find more information on this. I came across...more >>

Hi everybody, My company finally broke down and bought some new servers. I have a question about the easiest method to replace our current server with our new hardware ( with hi speed 15000 rpm drives!) We are using merge replication with push subscriptions. Our publisher & distributor are...more >>

I am trying transactional replication on tables with IDENTITY properties on the field that makes up the primary Key. I have NOT FOR REPLICATION on all fields with the IDENTITY property on both the subscriber and publisher. I ran the following script on both the publisher and subscriber because I ...more >>

Hi, I want to remove clustering of the Primary Key and make a foreign key in the table the clustered index. Can I do this with a replicated database? I suppose I hav to do this then on the Publisher and Subscriber database. Does anybody has any experience with this? TIA, Stefan ...more >>

can I change the owner of tables that are part of a merge replication without effecting that replication? or will I need to drop all replication, change owners, then re-setup replication? any info is appreciated. Thanks. ...more >>

How can i replicate oracle to sql ...more >>