It'a misunderstanding.

I do not use a stored procedure.

When you execute the following sql you get a warning.

But that's really no error!

There must be a possibitly.

if (1 = 0)

begin

...

Other question:

is it possible to disable or to configure the checks of the sql compiler?

How shall I call another procedure?

What do you mean?

Describe, please.

It is not possible to put both statements in one if-clause:

if (1 = 0)

begin

alter table tblCustAttrDefValue

add...

In this case it is not possible to use SSMS.

The requirement is to use a script which must be distributed.

I need a standard approch for "Change Ordinal Column Position" that...

Sorry, but that doesn't work.

A variable is only guilty in a batch.

Thank you for your help.

But my problem isn't really solved.

I have forget to say that I use two batches in my scripts:

if @nsqlver < 9.00304200

begin

print 'Wrong Server...

Yes, that's all right, but if you make a "SELECT * FROM tblXXX" on a table with 100 columns the columns should be logical sorted so that you find the...

Hello,

the reason for changing the column position is a design question.

I think the columns of a table should be logical sorted.

Regards Daniel

Thank you for you answer, Karl.

But I do not want to rename the table and then insert the data to the new table.

When you have big tables this approach is...