Posts

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! ...

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 .

Scripting Q&A

Q: How can I automate the FTP process so it runs on scheduler without user intervention? A: The FTP.EXE (File Transfer Protocol) command line utility comes standard with the Windows Operating system. Because it's a command line utility, it allows for many options to be entered at run time (simply enter FTP /? at the command prompt for a complete list). When using the -s: filename switch allows for the commands to be read from the filename specified. For example, first create a text file called myFTP.prm with the following commands: open www.myftpsite.com myUserID myPassword prompt off binary mput myfile *.txt From a command line, execute FTP -s: myFTP.prm . Please note there's no specific extension for file containing the FTP commands. For more info on this, please visit http://support.microsoft.com/kb/96269 Q: How can I execute a command line utility from with a VB Script? A: The CMD.EXE is a command line utility used for running other command...

What is a Tablix?

Image
The term "Tablix" can mean different things to different people. However, in the Microsoft realm it refers to the ability of SQL Server Reporting Services (SSRS) to combine a table and a matrix together.

Book Promotion from Packt Publishing

Image
Packt Publishing has recently released a new book titled " C# 2008 and 2005 Threaded Programming ". To help promote the new book, they have extended a 15% discount to members of the C#/VB.Net User Group. To take advantage of this offer, simply follow the 3 steps below: Visit http://www.packtpub.com/books and select any Packt title. Click the "ADD TO CART" button to add the book to your shopping cart. Now enter "CD15ug" (without quotes) in the 'Promotional Code' field and click the "Update" button. The discounted price should now be reflected in your order. Although Packt is based in the UK, they do offer free shipping to the US, with books arriving in only a few days. Packt Publishing has also sent a free copy to be given at an upcoming user group meeting. For more information, please visit http://www.packtpub.com/

March .Net Events

Mar 10th: .Net User Group (Using TFS). To register, go to http://www.bennettadelson.com/seat.aspx?sig=net&ID=141 Mar 12th: ONSQL User Group. To register, go to http://www.bennettadelson.com/seat.aspx?sig=sql&ID=141 Mar 14th: GCPCUG General Meeting (Switching to a Mac & Windows on a Mac). To register, go to http://www.gcpcug.org/ Mar 24th: Cleveland C#/VB.Net User Group (Writing Secure Code). To register, go to http://www.clevelanddotnet.info/ Mar 25th: Cleveland SharePoint User Group (TBA). To register, go to http://www.sharepointcleveland.com/default.aspx Mar 28th: Cincinnati Silverlight Firestarter. To register, go to http://cinnug.org/default.aspx .