anbillava (12/29/2008)
if i use SET IDENTITY_INSERT TableDelPrim ON and column list then i need to makeit for whole application. It takes lot of my time.
Is there any other work around. Pls let me know
Well, actually, you probably should rewrite your app to use SQL Server correctly. In all likelihood, you are going to have many other problems caused by not using Identifiers where you ought to.
How are you determining your ID values now?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]