From BAD To WORSE: A Disasterous Delete

From: John Bishop (ugradfrnd_at_aol.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 09:59:18 -0400

Last night, I posted the message "HELP!: A Disasterous Delete" (Friday,
October 29, 2004 1:20 AM). This morning, as I pressed ahead with my work
with my smaller data extract, I have had a recurrence of the problem of the
mysterious deletion of ALL RECORDS, but now with the smaller data extract.

But I have a better sense now of what may have CAUSED the problem (I think).
I had just used SQL Server Enterprise Manager to Change the Data Type of two
columns from char to nvarchar. I was then re-running a query. Thereafter,
in noticed that ALL ROWS of the table seemed to be missing.

Perhaps I am SPOILED by the way MS Access handles changes to a datastructure
with data records in place.

DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS
ALTERED??? This seems like a rather radical treatment to the data within a
table if this is the case.

Now I seem to have lost NOT ONLY the original larger 9 million record data
table, but also the smaller 350,000 record data extract.

Maybe I should just throw in the towel!

Any suggestions are appreciated!!

Relevant Pages

  • Re: From BAD To WORSE: A Disasterous Delete
    ... then dropping and renaming the temp table. ... > mysterious deletion of ALL RECORDS, but now with the smaller data extract. ... > DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS ...
    (microsoft.public.sqlserver.server)
  • Re: From BAD To WORSE: A Disasterous Delete
    ... > DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS ... Tibor Karaszi, SQL Server MVP ... > mysterious deletion of ALL RECORDS, but now with the smaller data extract. ...
    (microsoft.public.sqlserver.server)
Loading