Re: order of columns
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 10/05/04
- Next message: Amy: "Trigger Question"
- Previous message: duncans: "RE: Need help on multi-table query"
- In reply to: Bonj: "Re: order of columns"
- Next in thread: Hugo Kornelis: "Re: order of columns"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 5 Oct 2004 19:24:50 +0200
If you are sysadmin, you will be able to set an option that will allow you to perform direct
modifications of the data in the system table. The modifications suggested will trash your data.
It's like seeing a suggestion for a Windows system where they suggest you delete half of your
registry entries, or delete half of the files in your Windows directory.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "Bonj" <Bonj@discussions.microsoft.com> wrote in message news:4C9898CE-46D8-4A09-804E-DB7DDA5CEC04@microsoft.com... > OK, so it's an absolute load of b*&&@%£s that it works at all then, even with > sysadmin? > > > "Tibor Karaszi" wrote: > >> > DON'T USE THIS!!!!!! >> >> I absolutely agree. I sometimes use this technique when I *on purpose* want to corrupt/trash a >> database! >> >> Bonj, If you understand how SQL Server physically represent the data at the row-level, you will >> understand why this will corrupt the data. >> >> The article should be removed from that web-site. >> >> -- >> Tibor Karaszi, SQL Server MVP >> http://www.karaszi.com/sqlserver/default.asp >> http://www.solidqualitylearning.com/ >> >> >> "Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> wrote in message >> news:9pv4m01fmeafeabl45i67sr5a0doe1jmdt@4ax.com... >> > On Tue, 5 Oct 2004 10:20:01 +0200, Patrick Akerblom wrote: >> > >> >>Found this (use with care - updating system tables) at SQLServerCentral.com: >> > >> > DON'T USE THIS!!!!!! >> > >> > Sorry for yelling, but I felt an urgent warning was called for. >> > >> > Try changing the beginnen of the script to this: >> > >> > -- Create a table >> > CREATE TABLE tblRichTest1( >> > Column1 VARCHAR(100), >> > Column2 VARCHAR(100) >> > ) >> > GO >> > -- Enter some data >> > INSERT tblRichTest1 VALUES ('Column1 row 1', 'Column2 row 1') >> > GO >> > >> > -- Add a column >> > ALTER TABLE tblRichTest1 >> > ADD RichTestID INT >> > GO >> > >> > >> > Afte running the script, a SELECT * FROM tblRichTest1 yields (on my >> > system, character fields trimmed for posting): >> > >> > RichTestID Column1 Column2 >> > ----------- ------------- ------------- >> > 33554434 Column1 row 1 NULL >> > >> > >> > Best, Hugo >> > -- >> > >> > (Remove _NO_ and _SPAM_ to get my e-mail address) >> >> >>
- Next message: Amy: "Trigger Question"
- Previous message: duncans: "RE: Need help on multi-table query"
- In reply to: Bonj: "Re: order of columns"
- Next in thread: Hugo Kornelis: "Re: order of columns"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
