December 30, 2008 at 10:15 am
Glad I could help.
[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]
December 30, 2008 at 12:00 pm
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 easy way like..
alter table Table1
alter column [idTable1] IDENTITY (1, 1) NOT NULL
December 30, 2008 at 12:12 pm
Nope, sorry. No easier way than Enterprise Manager that I know of.
[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]
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply