Great. That's what I am looking for.

Regards,

Daniel

Thanks. It works.

Thank you for your hints.

I also think now that it is not good to shrink the transcation log to 1MB.

Although the recovery mode is set to simple (so only the...

Why not?

I only want to use some databases in a testing enviroment.

Thanks for your help.

Normally I should know this.

My idea is to change the recovery model and to shrink the transaction protocol with a script.

The change the current database.

See as the...

Thanks kruti, it works.

I think I make it with dynamical sql.

Last questions:

- Is there no workaround to have two batches in one if-condition?

if (level = 1)

begin

alter table tblCustAttrDefValue add strHelpValue...

It was just for testing

This solution is really messy.

At first I thought it works.

But when I when a make the following "SELECT", the column "strHelpValue" is missing:

select *

from tblCustAttrDefValue

Any other ideas?

Has anybody experience with...

Unfortunately this doesn't work:

Here the code:

if (select nDbSubVersion from tblVersion) = 2

begin

alter table tblCustAttrDefValue add strHelpValue varchar(200) null

end

go

if (select nDbSubVersion from tblVersion) = 2

begin

update...

The second possibility I do not understand:

It's that, or break the batch using GO

Can you describe it?

What do you mean by dynamic SQL?

I hope not "EXEC".

Yes I post a similar case a few months back.

My problem is the following:

I want to add column and then modify the column in a if-clause.

Theoretical it should be:

if (level...

You are right, it's a syntax error at compile time.

Is there any chance to suppress this syntax error?

Do you have a workaround?

My problem is that even though the condition is false, the sql compiler throws an error for the statement in the condition.