Wednesday, April 08, 2009

Set the identity specification on a primary key

Q: I always used databases provided by Microsoft to practice on. Today I tried to create my own and ran into trouble. Problem is that I cannot set the identity specification on a primary key. The column properties show up as no and I cannot change it to yes. I’m using SQL Server Express 2005 on a Vista machine. Any thoughts?

A: . To change column properties, you must modify the table (right click table and select “Modify”). Select and highlight the column you want to change, then expand the “Identity Specification” in the “Column Properties” pane. Change the “Is Identity” property to “Yes”. Please note the change must be made to the “Is Identity” property, not the “Identity Specification”.

IT Events Sponsored by Sogeti

The Cleveland office of Sogeti USA will be hosting the following IT events in April.

April 21: Taking the cost out if IT
Time: 2:30 p.m. – 4:30 p.m.
Location: Microsoft Office 6050 Oak Tree Blvd. Independence, OH 44131
Agenda:
> Introductions Microsoft and Sogeti
> Taking the Cost out of IT
> Break
> Optimizing Microsoft Solution Delivery
> Testimonials
> Open Forum
To register, go to http://www.clicktoattend.com/ then enter Event Code: 137141


April 30: "Me the Media - Rise of the Conversation Society"
Date: Thursday, April 30, 2009
Time: 6:00 p.m. – 8:30 p.m.
Location: Beacon Place (lower level conference room), 6055 Rockside Woods Blvd. Independence, OH 44131
The speaker at this event will be Erik van Ommeren,who is managing the US branch of the Sogeti InternationalResearch Institute for New Technology. He is an author andpublic speaker on topics such as innovation, collaboration,service oriented architecture, crowdsourcing and new media. You’re invited!
RSVP by 4/27/09 to sue.fellner@us.sogeti.com

April 2009 .Net Events

Listed below are .Net related events for April 2009:

April 9: Ann Arbor Cloud Camp (http://bit.ly/a2cc)
April 9: Ohio North SQL Server User Group - Executive Dashboards using SharePoint 2007 (http://www.bennettadelson.com/seat.aspx?sig=sql&ID=141)

April 14: .Net User Group - Silverlight 3.0 Beta (http://www.bennettadelson.com/seat.aspx?sig=net&ID=145)

April 28: Cleveland C#/VB.Net User Group - IronRuby (http://www.clevelanddotnet.info/)

April 30: ArcReady (www.arcready.com)
April 30: MSDN Unleashed (http://www.msdnevents.com/unleashed)
April 30: TechNet Unleashed (http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032410537&Culture=en-US)
April 30: Cleveland Architecture SIG.