Today I need to copy 8 records in a table. I have to use Access 200 because
of the limitation of Enterprise Manager's inability to cope with field with
more than 900 characters. Selected records, cut, paste. I got an erroor
message about not being able to have a null Key_ID (I copied the reords and
tried to paste the Key_ID as part of the records - normally I hide the
Key_ID).
Now I can't access either the new records or the originals that I was trying
to copy (because, it would seem, they have identical primary keys). I also
cannot export the table via DTS 'unspecified error' and 'integrity
violation'.
Or delete the offending records with a Query Anaylyser delete query.
Basically the entire SQL Server database has been destroyed with a couple of
keystrokes.
Now, I've being developing database applications for over 20years and the
one thing, maybe the only thing I expect from a database server is to
protect the integrity of my data. SQL Server does not, it would seem. These
records aren't just any random unimportant records either. They contain the
'create views' that my entire application require to function and each one
approaches the 8000 record limit and have take years to perfect and just
checking that the table is valid could take me days. 5 1813
sorry if this sounds like a couple of dumb, obvious questions:
- do you have backups of this important code?
- are you able to drop the constraints on the table, remove the offending
records and reapply the constraints?
regards,
stephen
"pete" <pe**@madpete.f reeserve.co.uk> wrote in message
news:40******** **************@ news.zen.co.uk. .. Today I need to copy 8 records in a table. I have to use Access 200
because of the limitation of Enterprise Manager's inability to cope with field
with more than 900 characters. Selected records, cut, paste. I got an erroor message about not being able to have a null Key_ID (I copied the reords
and tried to paste the Key_ID as part of the records - normally I hide the Key_ID). Now I can't access either the new records or the originals that I was
trying to copy (because, it would seem, they have identical primary keys). I also cannot export the table via DTS 'unspecified error' and 'integrity violation'. Or delete the offending records with a Query Anaylyser delete query. Basically the entire SQL Server database has been destroyed with a couple
of keystrokes. Now, I've being developing database applications for over 20years and the one thing, maybe the only thing I expect from a database server is to protect the integrity of my data. SQL Server does not, it would seem.
These records aren't just any random unimportant records either. They contain
the 'create views' that my entire application require to function and each one approaches the 8000 record limit and have take years to perfect and just checking that the table is valid could take me days.
Yes I have a backup from yesterday, but it was a 14hour day and I don't ever
want to reapeat it.. But your sugguestion about removing the constraint
helped, I could delete them. Thanks.
"SWu" <sw@rgrzz.com.a u> wrote in message
news:uu******** ******@TK2MSFTN GP11.phx.gbl... sorry if this sounds like a couple of dumb, obvious questions: - do you have backups of this important code? - are you able to drop the constraints on the table, remove the offending records and reapply the constraints?
regards, stephen "pete" <pe**@madpete.f reeserve.co.uk> wrote in message news:40******** **************@ news.zen.co.uk. .. Today I need to copy 8 records in a table. I have to use Access 200 because of the limitation of Enterprise Manager's inability to cope with field with more than 900 characters. Selected records, cut, paste. I got an erroor message about not being able to have a null Key_ID (I copied the reords and tried to paste the Key_ID as part of the records - normally I hide the Key_ID). Now I can't access either the new records or the originals that I was trying to copy (because, it would seem, they have identical primary keys). I
also cannot export the table via DTS 'unspecified error' and 'integrity violation'. Or delete the offending records with a Query Anaylyser delete query. Basically the entire SQL Server database has been destroyed with a
couple of keystrokes. Now, I've being developing database applications for over 20years and
the one thing, maybe the only thing I expect from a database server is to protect the integrity of my data. SQL Server does not, it would seem. These records aren't just any random unimportant records either. They contain the 'create views' that my entire application require to function and each
one approaches the 8000 record limit and have take years to perfect and just checking that the table is valid could take me days.
pete (pe**@madpete.f reeserve.co.uk) writes: Today I need to copy 8 records in a table. I have to use Access 200 because of the limitation of Enterprise Manager's inability to cope with field with more than 900 characters. Selected records, cut, paste. I got an erroor message about not being able to have a null Key_ID (I copied the reords and tried to paste the Key_ID as part of the records - normally I hide the Key_ID).
Now I can't access either the new records or the originals that I was trying to copy (because, it would seem, they have identical primary keys). I also cannot export the table via DTS 'unspecified error' and 'integrity violation'. Or delete the offending records with a Query Anaylyser delete query. Basically the entire SQL Server database has been destroyed with a couple of keystrokes. Now, I've being developing database applications for over 20years and the one thing, maybe the only thing I expect from a database server is to protect the integrity of my data. SQL Server does not, it would seem.
SQL Server protects the integrity of your data, as far as you tell it
what to protect. It cannot make random guesses.
In any case, it is impossible to tell what happened, since you also
involved Access. "Cut and paste" is not a concept that exists in
SQL Server proper. If Access implemented the cut-and-paste with a
DELETE and INSERT, and the INSERT failed, and did not use a transaction,
then SQL Server have to plead innocent.
These records aren't just any random unimportant records either. They contain the 'create views' that my entire application require to function and each one approaches the 8000 record limit and have take years to perfect and just checking that the table is valid could take me days.
It seems a little funny to me that you store source code in a database
table. I would use a version-control system.
But assuming that you had created the views, you can use sp_helptext
to get SQL Server's version of the views. There are also scripting
facilities in Enterprise Manager.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
If you have a field name of more than 900 characters, then its your own
silly fault.
On the other hand it could be that you had a unique index on that was
created with(nocheck), which would explain why you could delete records, but
couldn't put them back in again.
"pete" <pe**@madpete.f reeserve.co.uk> wrote in message
news:40******** **************@ news.zen.co.uk. .. Today I need to copy 8 records in a table. I have to use Access 200
because of the limitation of Enterprise Manager's inability to cope with field
with more than 900 characters. Selected records, cut, paste. I got an erroor message about not being able to have a null Key_ID (I copied the reords
and tried to paste the Key_ID as part of the records - normally I hide the Key_ID). Now I can't access either the new records or the originals that I was
trying to copy (because, it would seem, they have identical primary keys). I also cannot export the table via DTS 'unspecified error' and 'integrity violation'. Or delete the offending records with a Query Anaylyser delete query. Basically the entire SQL Server database has been destroyed with a couple
of keystrokes. Now, I've being developing database applications for over 20years and the one thing, maybe the only thing I expect from a database server is to protect the integrity of my data. SQL Server does not, it would seem.
These records aren't just any random unimportant records either. They contain
the 'create views' that my entire application require to function and each one approaches the 8000 record limit and have take years to perfect and just checking that the table is valid could take me days.
Beeeeeves (beeeeeeeeev@ve s) writes: On the other hand it could be that you had a unique index on that was created with(nocheck), which would explain why you could delete records, but couldn't put them back in again.
There is NOCHECK for indexes. You can say NOCHECK with UNIQUE and PRIMARY
KEY constraints, but it does not have any effect. NOCHECK only applies
to CHECK and FOREIGN KEY constraints.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Andrew Thompson |
last post by:
It seems most people get there JS off web sites, which is
entirely logical. But it is also a great pity since most
of that code is of such poor quality.
I was looking through the JS FAQ for any question that
identifies the warning signs to look out for, the things
that most easily and clearly identify the author of code
as something less than a master of the art.
I did not find an FAQ that answered it, but I think the FAQ
|
by: andree |
last post by:
Hello,
I have a form where a user may paste multiple records. The form has an
AfterInsert procedure. The procedure copies the newly inserted record
into a different table for audit purposes.
When one record is pasted, all is working fine. If multiple records
are pasted, the AfterInsert event gets fired before the Paste
Confirmation Dialog Box, therefore no records are inserted into my
audit table.
|
by: Pete |
last post by:
Does anyone have a simple html vbscript or other type of snippet they
can share that appends a record to a access database via ADO or DAO?
I would like to allow users that don't have Microsoft Access a way of
adding records to a access database from a simple web page. I don't
want to have to setup ODBC or anything like that I just want to put
the web page on the network for anyone to access. Most of the users
would use the local access...
|
by: PalJoey |
last post by:
I am having a problem copying and pasting records into the same table.
When I copy a record that has a zero length string for a field Access
seems to convert it to NULL when pasted. One of the fields does not
allow NULLS so I cannot paste the record. I get the error "You tried
to assign the null value to a variable that is not a variant data
type". I know which field is causing the error b/c when I change it
from a zero length string to...
|
by: Fendi Baba |
last post by:
I created a person table with various fields such as Suffix,
Salutation, etc, Some of these fields may not be mandatory for example
suffix. In the actual table itself, I only have a field for suffix ID
where 1=Phd, 2= MD. To display all of these to the user, I created a
form with an underlying query. The problem I am encountering is this,
when we have an empty field, for example where ID="", the query returns
nothing. How do i work around...
| |
by: dimitris.papastamos |
last post by:
Hello everyone, I've been working on a simple editor myself and I seem
to be having some problems with ncurses or so. I have been debugging
this program quite a lot trying to detect where the bug is hiding. If
you try to compile it gcc -o rosy rosy.cpp -lncurses and run it with
an input file, the delete and backspace characters function great
however when you start pressing keys like, right left or so to
navigate through the file, it...
|
by: kcdoell |
last post by:
Good morning everyone:
I created a form and set the default view as a continuous form. Basically the form is displaying records in which the user can add or edit new ones. The record source for this form is a query that I built that is based on a table.
I have been working on this for several weeks and now I have been told that many times when a user wants to create a new record, much of the information that is displayed in a...
|
by: phill86 |
last post by:
Hi I have a main form that holds records for scheduled meetings, date time location etc... in that form i have a sub form that has a list of equipment resources that you can assign to the meeting in the main form. I have two buttons in the sub form one for selecting and copying all the records and another for pasting the records this enables me to copy and paste the equipment resources from one scheduled meeting to another.
The buttons are...
|
by: Phil Stanton |
last post by:
My Ak2 databas has been running successfully for many years althogh it gets
upgraded regularly.
I now find on this, and other dbs, when I delete a record I no longer get
the message "You are about to delete 1 record.....".
What has gone wrong / got changed?
Thanks Phil
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |