but what if he cannot be member of sysadmin?

i need to use these functions to dump into text files, what would be the solution if the user is a normal...

Yeah but am not using raiseerror

so what u are saying is that i replace my print by a raiseerror , and the...

COOL!

one more question then, since i wont be using a raiseerror, i want to dump the error into a text file. but the user who executes the query doesnt have...

well it's what i already wrote... and i am executing it on the db on the server and i get 0

declare @result int

great help, tx a lot!

now in my case where i am reading a temp table line by line using a cursor, i want in case of an error in one...

hey guys

i just read the comments, and right, am not done yet

and oh.... am a female

tx for ur advices!

but i don't really get it how can i drop the cursor while i need it to read the temptable and insert into my db?

whether i predefine...

this is my code... u don't have to understand much of it but you will see that there is the same update or insert instructions many times

GO