Re: From BAD To WORSE: A Disasterous Delete

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 16:15:43 +0200

> DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS
> ALTERED???

No. You have either hit a bug, or something went very wrong. But without a repro, it is hard for us
to comment any further. Most of us prefer to execute TSQL statements from Query Analyzer for these
types of changes as it gives us better control, and we know exactly what commands are executed... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"John Bishop" <ugradfrnd@aol.com> wrote in message news:eDbrR9bvEHA.3896@TK2MSFTNGP09.phx.gbl...
> 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

  • From BAD To WORSE: A Disasterous Delete
    ... but now with the smaller data extract. ... I had just used SQL Server Enterprise Manager to Change the Data Type of two ... DOES SQL 2000 DELETE ALL RECORDS WHEN THE DATA TYPE OF A SINGLE COLUMN IS ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Express - Identity specification property - how to change
    ... FOO_ID int identity, ... Tony Rogerson, SQL Server MVP ... They are making unfortunately frequent use of the IDENTITY column in conjunction with Primary Key. ... IDENTITY has none of the properties of a data type because it is not a data type at all. ...
    (comp.databases.ms-sqlserver)
  • Re: Type Mismatch Error Message
    ... >> Using Text as SQL data type. ... I created a database on a SQL server manually and matched the column names ... I thought you "didn't use the database wizard?" ... >> Data type in form is No Constraints. ...
    (microsoft.public.frontpage.programming)
  • Re: DISP_E_TYPEMISMATCH with OWC11
    ... you think its related to what data type OWC is expecting from the SQL ... I have a SQL ... Dim objChartspace, objChart, c, objConn, objRS, axis, sql ... An unhandled exception occurred during the execution of the ...
    (microsoft.public.office.developer.web.components)
  • Re: Cant believe it - Back Again Already! - How to set variables to Type in SQL Statement?
    ... "Marshall Barton" wrote in message ... >>the way to set the SQL variables to assume the data types of the field. ... >>would allow it to assume the data type of the field to update to. ... > strSQLUpdate = strSQLUpdate _ ...
    (microsoft.public.access.modulesdaovba)