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:50:47 +0200

> Enterprise Mangler

First time I've seen that one. LOL... 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Geoff N. Hiten" <SRDBA@Careerbuilder.com> wrote in message 
news:uVR4iYcvEHA.536@TK2MSFTNGP11.phx.gbl...
> Enterprise Mangler often does a table shuffle under the covers when making
> changes to tables.  You can see exactly what it intends to do by saving the
> change script before saving changes.  As Tibor points out, many of us prefer
> to do things via T-SQL because we know exactly what is happening.  EM is a
> good tool, but sometimes the way it wants to do something is not the way I
> want it done.
>
> -- 
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> I support the Professional Association for SQL Server
> www.sqlpass.org
>
> "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

  • Re: Back up on remote computer.
    ... Microsoft SQL Server MVP ... I support the Professional Association for SQL Server ... > Good one, Geoff,. ... >> Senior Database Administrator ...
    (microsoft.public.sqlserver.server)
  • Re: ActivePassive to ActiveActive
    ... "Geoff N. Hiten" wrote: ... You have a Single-instance, two-node cluster. ... Instance will act as an independent SQL Server. ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: From BAD To WORSE: A Disasterous Delete
    ... Enterprise Mangler often does a table shuffle under the covers when making ... You can see exactly what it intends to do by saving the ... I support the Professional Association for SQL Server ... > mysterious deletion of ALL RECORDS, but now with the smaller data extract. ...
    (microsoft.public.sqlserver.server)
  • Re: error during install
    ... Microsoft SQL Server MVP ... "Geoff N. Hiten" wrote: ...
    (microsoft.public.sqlserver.clustering)
  • Re: Installing MSDTC on a cluster
    ... "Geoff N. Hiten" wrote: ... Microsoft SQL Server MVP ... Do we need separate IP for Analysis Services? ...
    (microsoft.public.sqlserver.setup)