linked data bases

paul Borowski

We recently copied(replicated) a data base for development. everything went
well until yesterday we had rows start to disappeared in the source data
base. I then found out that the rows disappearing from the source data base
were being deleted from the database copy and this was being replicated in
the source database. I am sure this is a great feature but I need to stop
it from doing this. HELP

thanks
paul

Feb 23 '06 #1

Subscribe Post Reply

1181

Erland Sommarskog

paul Borowski (pa***********@ohr.gatech.edu) writes:

We recently copied(replicated) a data base for development. everything
went well until yesterday we had rows start to disappeared in the source
data base. I then found out that the rows disappearing from the source
data base were being deleted from the database copy and this was being
replicated in the source database. I am sure this is a great feature
but I need to stop it from doing this. HELP

You set up replication, and now you don't want replication to occur?
I guess that you just delete the subscription and/or the pubication
then.

If you only wanted a one-time copy, you should probably have used
snapshot replication.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Feb 23 '06 #2

by: Chris Ritchey | last post by:

Hmmm I might scare people away from this one just by the title, or draw people in with a chalange :) I'm writting this program in c++, however I'm using char* instead of the string class, I am...

C / C++

Bad performance in queries with Jet4.0 and linked ODBC-tables to SQL-Server 2000

by: Andreas Lauffer | last post by:

I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...

Microsoft SQL Server

Linked List

by: Dream Catcher | last post by:

1. I don't know once the node is located, how to return that node. Should I return pointer to that node or should I return the struct of that node. 2. Also how to do the fn call in main for that...

C / C++

How to open multiple data bases from one GUI

by: Tom Weston | last post by:

Help I have 4 databases containing different data relating to safety, not written by me. It is not possible to merge the databases into one large data base. I would like to create a user interface...

Microsoft Access / VBA

linked table manager

by: Javier Gomez | last post by:

I have the following problem: After updating my Access 2003 to SP1 my linked table manager is always empty. I do know that I have a several linked tables on my DB. 1- I tryed to repait my...

Microsoft Access / VBA

generalised linked list routines - opinion appreciated

by: Steve Lambert | last post by:

Hi, I've knocked up a number of small routines to create and manipulate a linked list of any structure. If anyone could take a look at this code and give me their opinion and details of any...

C / C++

URGENT Error: CS0117: 'System.Data.DataTable' does not contain a definition for 'WriteXml'

by: Luis Esteban Valencia | last post by:

Compilation Error Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source...

ASP.NET

maps to hold ultra large data sets using customer allocators to allocate disk space rather than main memory

by: CMOS | last post by:

one of the projects im working in currently requires use of ultra large sized maps, lists, vector, etc. (basically stl containers). Sizes might grow up to 1000 Million entries. since it is...

C / C++

linked list template class doesn't compile

by: QiongZ | last post by:

Hi, I just recently started studying C++ and basically copied an example in the textbook into VS2008, but it doesn't compile. I tried to modify the code by eliminating all the templates then it...

C / C++

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

Similar topics