thank you very much brother. i will look into that... and keep you post on further updates

There are different instance of generating id.. Most of which i can replace by identity. But in one case a random number will created by one of method and also...

if i use SET IDENTITY_INSERT TableDelPrim ON and column list then i need to make

it for whole application. It takes lot of my time.

Is there any other work around....

Thats true. but if i set identity then i can not have my(user) own value to be entered there.

i am using delete. Lets me give an example

Lets say there are 3 tables

Table1(a1,b1,c1,d1) a1 is primary key

Values....

1,b1,c1,d1

2,b1,c1,d1

3,b1,c1,d1

Table2(a2,a1,c1,d1) a2 is primary key and a1 is foregin key ref.. Table1

Values....

1,1,c1,d1

2,1,c1,d1

Table3(a3,a1,c3,d3) a3...