I had hooked up listviews to my db tables but I didn't have my identity columns setup so when I went in and changed the PK's to be auto-incremented identity columns I get an error telling me to enable insert_identity.

Well, after about 20mins of google searching I get absolutely nothing on how to change it whithin SQL Server Management Studio. Everything was examples of how to do it whithin code.

This is frustrating because I have really tried to look for it in Maganment Studio but I just can't find an Identity_Insert option.


Oh, and Merry X-Mas!

Hi there,

Take a look at page 422 and further, and at step 5 of the Try It Out exercise in particular.

Cheers and Merry Christmas to you too!

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!