Thanks for the reply.

CAn you please tell me how to do that ?

I have situation where in if user enters same data then i need throw him a error message depending up on the primary key violation. Each row in the...

I have all the table information in one table

and table columns stored in another table with reference.

First i will iterate thrugh table data then

for each value in the table...

Currently i am solving it through some other means.. but its taking nearly 3 hours to execute..

So i thought of getting some suggestions here....

I need to find a different...

Table1

idtable1 a1 a2 a3 ...

Can we make this dynamic. I have similar problem. I need to check missing data varables in different tables dynamically.

Variables position in each table are fixed.

For e.g

1. Table1

idtable1 a1...

so u guys are tellign its hard to acheive by reading some docs

I am able to do it by some of other posts in the portal. Thanks for all your info. I am actually working mas data archive and restore stuff. During...

Hey Please tel me more about security risks in sql server like sql injection. I dont much

about all this.

I got it. you are talking about string characters (escape) etc. It does not depend on the

user input.

I wrote a scalar function get column names dynamically with column seperated...

But i dint understand about security risk ?

Is there any way to alter identity column through TSQL. I know that if i do it

from EM i can save the changed script. But that will be very costly.

Any...

I am feeling better now. Thank you very much...

If i have understood u correct.....

Those ids will change if i do so. Because these ids are interlinked

with other tables.

For e.g

I have a transaction like this

Table1 with column idTable1,...

With the identity after deleting some of the item its possible to insert same id values

with identity insert option setting on. Is there any way to override this. ?