That issueis solved but at any point of time the #ErrFile contains only' 0' as the value,irrespective of any error happens during the master procedure exectuion. :blink:

What could be...

thank you!!! that worked:cool:

yes i am sure and we have also tested.The particular block is synchronised so it can be accessed by one thread at a time . It's equal to locking the...

hi,

i have no problem in the client code writtten i have problem in my we application which is written in java and as of now it doesnt support...

No i dont have any such file thats the problem.The component i use for data insert through my web application needs the Id value to be given and it doesnt...

also i cannot have a primary key column with Identiy enabled since my web application(Java based) is not coded to handle it that way.

thanks,

prem

yes i a wrong 🙁

only one table have identity_insert on for a given session. so my logic wont work.

Guys my application is an report generator where end user enter...

Hi all,

Thanks for the interest you all have shown.

I have completed my requirement by doing identity insert off during the datamigration and then turning it on...

Hi ,

I thought of dropping and adding primary keys but the problem is that the script turns out to be more complex since there are certain tables whose...

Hi shamshudheen ,

Thanks for your intreset.I could do the way u have mentioned if the column is not a primary key but unfortunately its a primary key...