114 reputation
4
bio website mrab.de
location Germany
age 36
visits member for 1 year, 4 months
seen Apr 26 '12 at 11:51
stats profile views 1

blubs


Mar
16
awarded  Autobiographer
Mar
12
awarded  Scholar
Mar
12
accepted Columns are added in wrong order
Feb
14
awarded  Teacher
Jan
31
answered Columns are added in wrong order
Jan
31
comment Columns are added in wrong order
Sorry, last comment containt only a part of the statement. Here is the rest: This explanation fits the situation and if it would match my experience I would totally agree. For example if you run two while loops adding up integers each in one batch. The first batch runs to 1000000, the second just to 100. I never got the second result first. Or if you use SSMS to generate a "create table"-script you'll find a lot of GO statements where a reordering would have fatal effects.
Jan
31
comment Columns are added in wrong order
This explanation fits the situation and if it would match my experience I would totally agree.
Jan
30
comment Columns are added in wrong order
The update ran just on some test (lab / early adaptor) machines. It went wrong in about 10 out of 20 runs. It occurs just on few tables (all with similar structure, >100 columns, all int, bit or char(16)).
Jan
30
comment Columns are added in wrong order
MSSQL express 2k5.
Jan
30
comment Columns are added in wrong order
I'm running them during an update procedure that calls osql with the -i parameter.
Jan
30
awarded  Student
Jan
30
comment Columns are added in wrong order
No. It's all in one schema and there is just one schema.
Jan
30
comment Columns are added in wrong order
I assume this. Although it would be really weird as both batches are in a single file!
Jan
30
asked Columns are added in wrong order