sorry, didn't undestood very well the:

" yes, kill will rollback the transaction. Proof if that is Use kill with the statusonly clause will tell you how rollback is progressing if...

The case is this:

suppose i have a procedure, that executes the following:

create proc test ()

as

begin

update table1 ................

Insert into table 2...............

Update table 3....................

insert...

Thank you very much for the reply. I undestood.

What about the stored procedure? while it is killing the processes, it will...

Thank you very much for the reply. I undestood.

What about the stored procedure? while it is killing the processes, it will...

I have seen your link. thank you

I have seen taht the variable @@error is not affected by the "Set nocount on".

But, what about the:

@declare erro int

set @erro =@@erro

The variable that...

It's done, tks.

What about the:

"Set nocount on" does this instructuction affects the error count (@@error) inside the stored procedure while it is executing?

Or the Set nocount on, only affects the...

Hi Masters,

Thank you very much for all the advices.

I made it, other way....

I have created the table (bulk_contribuintesest), taht the view needs to be constructed.

Then, i crate the...

Yap, it's 20.

I will convert and add the lenght.

Thank you,

Pedro

thank you very much.

I have converted to varchar and it worked.

As to the app that you recomended, i will take a look.

Once again thank you very much to you all.

Pedro

Hi,

Yap, there's other reason.

With the result of the select i will trie to produce a txt file (script) that as insert statements.

This script will be sent to other database...

Hi- the process will run like this:

i have made a VB APP, that as a botton.

The person (when people are not working) , clicks on that botton...

Hi- thank you very mutch for reply.

In this case, i think that there is no problem.

I could create as you say, a temporary table (#temp) wich would be just...

Hi Mike,

Thank you very much, once again.

I understood why DDL statements can cause the locks.

But in this case, because the procedure was coded like below:

alter...

Hi - Mike,

First of all, thank you for your wonderful help.

AS to your explanations, i undestud almost everything.

The only part that i did not undestud it's...

It worked. Now i can have everything on the same procedure.

But i don't understand why it worked....

let me see if it's because of this:

It worked because with dynamic SQL statements...