Re: From BAD To WORSE: A Disasterous Delete

From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 10:46:53 -0400

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: From BAD To WORSE: A Disasterous Delete
    ... >> Enterprise Mangler ... > Tibor Karaszi, SQL Server MVP ... >>> table, but also the smaller 350,000 record data extract. ...
    (microsoft.public.sqlserver.server)
  • Re: Longest SQL runtime??
    ... What does "stop saving" mean? ... Do you get an error message at runtime, ... I have had much longer uptimes than that with databases measured in the ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: From BAD To WORSE: A Disasterous Delete
    ... Tibor Karaszi, SQL Server MVP ... "Geoff N. Hiten" wrote in message ... > Enterprise Mangler often does a table shuffle under the covers when making ...
    (microsoft.public.sqlserver.server)
  • Re: drawbacks of Saving documents to Sql server
    ... Retrieving the files from the file system is always faster but not necessarily better. ... In the database I used a table to store a "header" record with one row per file containing the filename, filesize, number of 64K chunks, etc... ... SQL Server 2005 performs better than SQL Server 2000 hands down. ... that microsft is gong more towars saving everthing in sql server. ...
    (microsoft.public.dotnet.framework)
  • Re: Hide databases in EM/QA
    ... Unfortunately, with SQL Server 2000, using Enterprise Mangler and Query ... Most good judgment comes from experience. ... How can I hide all other databases from client? ...
    (microsoft.public.sqlserver.security)