Rating Thread / Thread Starter	Last Post	Replies	Views
Snapshot is not the answer Ok, this is a strange problem, my company uses a software solution that has a SQL backend, the solution is based originally from an as400 database... Patrick K	03-18-2005 02:18 PM Khooseeraj Moloye	3	73
Replication setup via VB.NET I have a VB.NET program that is executing the SQL commands to setup replication. I am getting an error (A severe error has occured) on... Darin	03-18-2005 12:27 PM Darin	5	80
SQLDMO and asp.net I have this little piece of code that works in VB.NET but NOT in ASP.Net and was wondering if anybody can help. In the part of the code that goes... MSSQLServerDeveloper	03-18-2005 09:44 AM Ryan Walberg [MCSD]	1	79
Multiple publications Is it possible to have 2 different transactional replication models/publications coming from the same database (using same tables sometimes but... Peter Doyle	03-18-2005 05:00 AM Geoff N. Hiten	1	67
How to drop merge replication system tables Hi, we have a database wich used merge replication. We disabled merge on this db, but '%onflict%' system tables persists, leading to error when... Roberto Souza	03-18-2005 03:21 AM Paul Ibison	2	90
Error creating distributor hi, Every time when i create a Distributor on a local server, it always said Error 14234: The specified '@server' is invalid (valid values are... Ed	03-18-2005 03:16 AM Paul Ibison	1	70
Transactional Replication hi, If I have one publisher and more than one subscribers, when i check on the option "Immediate updating", i understand what it does is to update... Ed	03-18-2005 03:11 AM Paul Ibison	2	84
Transactional replication, pull subscription, does distribution agent on publisher poll distributor In regards to transactional replication using a pull subscription (set to continuous) - the distribution agent runs on the subscriber. How does... John Eyles	03-18-2005 03:07 AM Paul Ibison	1	71
Transactional Replication, does a pull subscription require anything other than port 1433 thru firewall In regards to Transactional Replication, using a pull subscription through a firewall (distributor and publisher are on the other side of the... John Eyles	03-18-2005 03:06 AM Paul Ibison	1	81
Transactional Replication, replication of 23 GB database over WAN to overseas site We have the following configuration: Transactional replication (one way); Publisher and distributor are local, with subscriber through a firewall... John Eyles	03-18-2005 03:04 AM Paul Ibison	1	85
Log Shipping Problem - Pls help me Dear Friends Thanks to Pual. Now if i want to do the following solution suggested by Mr. Paul it is giving me problem as when i take the database... Sharad	03-18-2005 02:51 AM Paul Ibison	1	70
Dropping a table from replication Transaction replication: Please help. I am new to replication. I have setup Transaction replication between two databases. The replication is... Sam	03-17-2005 04:21 PM ChrisR	1	79
how much time to set up replication Does anyone know how much time (approximate) I should allocate to set up Transactional Replication on a SQL database that is 20 gig in size? Patrick K	03-17-2005 01:45 PM ChrisR	1	67
To Replicate or Not to Replicate? Scenario: Two sql servers connected via WAN(central US and western US). Requirement: Union the results of a proc from 3 identical tables in each... michelle	03-17-2005 01:20 PM michelle	1	81
Error 22022 when setting up replication Trying to set up a publisher and it fails on creation with this error: Error 22022 Unable to post notification to SQL Server Agent. Publication then... JMKitts	03-17-2005 12:53 PM JMKitts	0	112
Is this scenario possible? Transactional Replication. Box1: Publisher Box2: Reporting only Subscriber Box3: Updateable Subscriber If Box1 modifies data, it obviously goes to... ChrisR	03-17-2005 12:48 PM ChrisR	5	69
LOGREADER NOT START When I try to start the agent (replication monitor->Agents -> log reader Agent - with red cross). show me this error : 22022 sqlserveragent error:... Alioscha Debali	03-17-2005 12:22 PM Alioscha Debali	0	81
Re: about transaction replication... This error is caused because sysdepends is out of sync on your publisher. All RDBMS's have this problem. The best thing to do is to pre create your... Hilary Cotter	03-17-2005 12:07 PM Khooseeraj Moloye	1	56
Interesting question hi, I am thinking if Transactional backup is based on the data in the Transaction Log. what if i set up a the Log Reader to be run every 1 hour, but... Ed	03-17-2005 12:06 PM Hilary Cotter	4	75
Transactional Replication with images Hi, I am trying to replicate blob in MS SQL 2000, I know it is not advisable from performance point of view but this the requirement. I am getting... Shan	03-17-2005 10:01 AM Shan	3	59
about transactional replication Hi, I have created a transactional replication on SQL Server 2000 with SP3. Only one database is being published with 70 tables. But when it begins... Ugur Ekinci	03-17-2005 06:53 AM Ugur Ekinci	3	86
Error Pull replication I have two Win2000 that are in a domain. SQL1(SQL server) acts as the distributor and publisher. SQL2(MSDE2000) acts as the subscriber. Push... Thang Long	03-17-2005 05:29 AM Thang Long	5	76
Error 18483 'distributor_admin' I'm trying to publish a database and when I get to the end of the wizard, I am greeted by this message: SQL Server Enterprise Manager could not... Ray Lewis	03-17-2005 03:20 AM benno2004	3	198
Msmerge_Tombstone table: Reason is system delete Thanks to reply to this post. I have SqlServer2000 running under XP and Windows Server 2000. Latest SP installed. I have seen a few cases in the... Khooseeraj Moloye	03-17-2005 03:01 AM Khooseeraj Moloye	0	119
Bandwidth and replicating over a low speed WAN Hi, We have transactional replication working fine in a plant. DataServer replicates every 5 seconds to AppServer so we have a copy of the... Peter Jones	03-17-2005 12:57 AM Peter Jones	0	61
Merge replication Hello, We have a merge replication setup across telephone lines. I want to add a new table - how can i do it without publishing the... Ishan Bhalla	03-16-2005 07:01 PM Ishan Bhalla	2	83
Replication Fails updating IDENTITY value at subscriber I have a situation where I want to use transactional replication and maintain the IDENTITY property at both the publisher and subscriber. I want to... bert	03-16-2005 06:46 PM bert	6	84
Not for Replication confusion According to BOL: For example, consider a table that contains rows inserted from two sources: Publisher A and Publisher B. The rows inserted at... ChrisR	03-16-2005 05:43 PM ChrisR	0	75
replication set up creates a linked server? Hello - I recently setup replication here & I have a question. In doing an audit of the SQL Servers the other DBA & I notice a linked server between... John F.	03-16-2005 02:47 PM Paul Ibison	4	81
Delete Subscriber Hi, I have two server, One is a publisher and one is a subscriber with Pull Type. After I use "Disable Publishing and Distrubution", I sucessfully... Ed	03-16-2005 02:13 PM Paul Ibison	1	85
better way to fix broken replication? If replication ever blows up with an error like: "The row was not found at the Subscriber when applying the replicated command." There is only one... ChrisR	03-16-2005 01:09 PM Hilary Cotter	4	71
SQL DBA needed in Monrovia, Ca. Im leaving my company and trying to help out with finding my replacement. Below is the job posting as listed on Dice. Please note this position is... ChrisR	03-16-2005 11:23 AM ChrisR	2	83
Could not bulk insert. Bulk data stream was incorrectly specified as sorted. hi, i am Oscar from Spain I have a mistake in Transactional publication. The Error message is "Could not bulk insert. Bulk data stream was... ocano ocano via SQLMonster.com	03-16-2005 10:53 AM Paul Ibison	7	368
Publisher/Distributor Hi, I would like to hear opinion from experts. Assume I have 3 warehouses and 1 Head office. I want to build a centralized Subscriber. should i... Ed	03-16-2005 10:40 AM Hilary Cotter	1	64
Initial SnapShot failure.... ( 1 2 ) I have a series of NT4 systems that I need to set up replication on. They have sp 6a installed on them I have done a clean install of SQL 2k Server... rob lynch	03-16-2005 07:57 AM rob lynch	16	139
Hi Availability over WAN advice Hi Team, Not sure of the best solution. I have two SQL servers in different parts of the country connected via a 3mb VPN WAN. Both are used for the... Andrew Jurgens	03-16-2005 05:17 AM Hilary Cotter	1	63
How can I determine which type of replication is running? I'm new to SQL Server replication and my company. There are several servers replicating data. How can I determine if snapshot, transactional,... apf	03-16-2005 03:51 AM Paul Ibison	1	76
Computer turns off while replication is taking place Hi What will happen if the Publisher or the Subscriber shuts off while replication is taking place Will that cause any problems or it will... S Shulman	03-15-2005 01:16 PM S Shulman	3	69
better solution i just find out if I check on "Delete data in the existing table that matches the row filter statement" instead of "Drop the existing table and... Ed	03-15-2005 12:09 PM Ed	0	77
Adding a column on a replicated table Hi, I need to add a column to a replicated table. Is there a way of adding a new column without dropping the whole replication? I went through the... Preeti	03-15-2005 10:07 AM Paul Ibison	1	73
Clustered Subscriber - Whose Ip Is It? I have a data warehouse transactional replication environment in which we have muliple Publisher/Distributors(100+) and a single subscriber. All... rum63	03-15-2005 09:01 AM rum63	0	73
BUG: sp_addmergearticle Hi everybody, I have the following configuration: Windows 2000 SQL Server developer edition, SQL Server SP3a I found out that the stored procedure... Roland Haulitusz	03-15-2005 08:52 AM Roland Haulitusz	0	99
Cannot insert duplicate key row in object 'MSmerge_tombstone' Hi, I have made a replication since 2004-08-21. it works well, but recently i got a problem. When i want to delete some records in a table, an... Jackson BF	03-15-2005 07:26 AM Paul Ibison	1	102
Replication Question about job names and categories I have a TSQL script to add daily tables to replication and then run the snapshot agent to distribute them to two subscribers. The script executes... war_wheelan@yahoo.com	03-15-2005 06:41 AM Hilary Cotter	1	94
Log Shipping problem Dear Friends I have a SQL Standard version and due to same i am not able to do the log shipping for the database i want to create a backup server... Sharad	03-15-2005 06:08 AM Paul Ibison	1	82
Easy way to sync Hi Guys, can anyone tell me a good open source project or tool that I can use to sync data over the dial-up conection different two SQL Servers? I... Sniper	03-15-2005 05:59 AM Paul Ibison	3	78
best choice hi, is using delete existing table and re-create one the best choice? I am thinking delete and re-create would take longer and drop the permission... Ed	03-15-2005 02:59 AM Paul Ibison	1	78
Please explain!!! Hi, I would like to make the concept clear that if i have two individual servers let's say one in CA and one in TX. i want them to be able to... Ed	03-15-2005 02:55 AM Paul Ibison	1	75
Error 3724 : cannot drop table ...becuase it is published for .... Dear helper, I have a database that running on SQL Server 7 and it has been published for replication for a period of time. After that period i... Ayman	03-15-2005 02:42 AM Paul Ibison	3	147
Relication merge library Hi Friends, We used SQLMERGXLib.SQLMerge in our VB.NET windows client application for calling sql server 2000 replication. Now we need to move to... Yong	03-14-2005 07:29 PM Hilary Cotter	1	103

Page 149 of 258

149

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off