As everything is in an Transaction (even the DROP TABLE), I hope the roll back of the transalation will be roolback !!!!

Otherwise, I think I will work on it

Yes I try it and it is working. I do not get the error code but the transaction is not commited which is the most important for me.

I heard and...

I think I found : SET XACT_ABORT ON.

From the doc, it seems that is stop any transaction running on the first error !

I understant what you wrote and I test : it is working but it's not working in my situation...

As I said, I execute a string that contains many request. Unlike...

So 'Iv trye this

DECLARE @STR AS VARCHAR(8000)

SET @STR = ' INSERT INTO T_B(UID, NAME) VALUES(''9c96812e-6210-4a4f-af6f-7027fc0f229f'', ''TEST'')'

SET @STR = @STR + ' INSERT INTO T_A(UID, UID_B, UID_C) VALUES (newid(), ''C7C86B92-EA59-4E4C-B7A5-499F69799C8C'', ''AFB38D28-7EA3-43C6-92B8-83EB9BE71505'')...

I think i've try with Execute() anf get the same result ...

But I'm gone try right now :o) !

Ouch !!!!

There is no way to know if there is an error in the Execute ?

In some case, it cab be bigger ... so i have to split ...

Stick to 8000 is better ?

We are talking between 1 Mo to in some case 25 Mo of text ...

I know that time I'm going to win on the network will be lost on my...

Sorry ... its SP ... Stored Procedure ...

Thanks !

But I would like to estimate the time before executiong the query ...

Ok ...

I will try again to see if this is better than drop ...

But what is the interest of a FK without check...

I've already tried but it seems that it also lock with a Sch-M ...

And yes ... I really need to ignore ...

But could you tell me what the main difference...