Category Archives: Uncategorized

Cannot insert explicit value for identity column in table ‘MyTable’ when IDENTITY_INSERT is set to OFF

When you try to insert data into a table with an IDENTITY column, the following error message may be returned.

 

Cannot insert explicit value for identity column in table ‘MyTable’ when IDENTITY_INSERT is set to OFF.

 

You will need to enable IDENTITY_INSERT, using the following statement.

 

SET IDENTITY_INSERT MyTable ON

GO

INSERT INTO MyTable

(Id, Name)

VALUES (123, ‘My name is Martin’)

GO

– Be reminded to reset IDENTITY_INSERT

SET IDENTITY_INSERT MyTable OFF

 

=== For more information ===

~ SET IDENTITY_INSERT (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms188059.aspx

Microsoft Certification coaching sessions!… With certification promotion code ( HKEBA99B )

Are you ready for Microsoft Certification? Sign-up to join the following Live Meetings to help you have a better understanding of Microsoft Certification and the coaching sessions to prepare for your Vista and SQL 2008 exams.

Certification 101: Getting Started with Microsoft Certification. Learn about the value, benefits, and process of getting certified: choosing a certification path, preparing for your first exam, taking an exam, and what to expect at March 10, 2009 (Pacific Time) : 7:30 A.M. or 5:00 P.M. Pacific Time.

Microsoft Certification Coaching Session: Preparing for your Configuring Microsoft Windows Vista Client Exam (70-620) at March 17, 2009 (Pacific Time) : 7:30 A.M. or 5:30 P.M. Pacific Time

Microsoft Certification Coaching Session: Preparing for your Microsoft SQL Server 2008, Implementation and Maintenance Exam (70-432) at March 24, 2009 (Pacific Time) : 7:30 A.M. or 5:30 P.M. Pacific Time

The good news – when you are ready to take the Microsoft Certification Exam, go to www.learnANDcertify.com by March 31, 2009 and key in the HKEBA99B to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.

Are You Certifiable? Compete in the ultimate Tech IQ Challenge!… With certification promotion code ( HKEBA99B )

Looking to test your expertise?  If you’re an IT pro or a developer considering certification, or if you simply want to sharpen your skills, then you may be interested in checking out “Are You Certifiable?”, a new online game from Microsoft and Fuel Industries.

The game takes the form of a trivia show, but includes a broad range of technical questions geared towards one of two disciplines:  Developer, or IT.  Some of the questions appear to be taken straight from the pages of Microsoft Certification, so it looks like a good primer for someone preparing to take a MS Certification exam.  Also, stay on the look out for “rogue” questions, usually in the form of trivia (does anyone know who invented the mouse?). Choose a character, select your field of expertise, and pit yourself against the entire online tech community in a quest for Tech IQ supremacy, a top spot on the leaderboard—and ultimate bragging rights.  

Check out the game at www.areyoucertifiable.com . The good news – when you are ready to take the Microsoft Certification Exam, go to www.learnANDcertify.com by March 31, 2009 and key in the HKEBA99B to obtain a 10% discount on your next Microsoft Certification Exam plus free retake if you fail plus the US$35 offer on eLearning. You will receive an email with the exam voucher code and a eLearning Promotion Code. Both offers will be valid till June 30, 2009. Happy Certifying…

 

Offer Details:

The certification promotion code ( HKEBA99B ) can only be used in Hong Kong.

The Offer is valid for a Microsoft Certified Technical Specialist (MCTS), Microsoft Certified IT Professional (MCITP) or Microsoft Certified Professional Developer (MCPD) exams. Not valid for Academic Exams.

Refer to the following links for applicable exams :
http://www.microsoft.com/learning/mcp/mcts/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/default.mspx
http://www.microsoft.com/learning/mcp/mcpd/default.mspx

Exam candidates must request an Exam Offer Voucher Code using the unique MVP Certification Promotion Code by March 31, 2009 via www.learnandcertify.com.

To receive a 10% discount on the cost of an applicable Microsoft Certification exam, exam candidates must use the Exam Offer Voucher Code provided by an MVP when they register for an exam and sit for an exam by May 31, 2009.

Limited to one (1) exam at 10% discount with a free retake (if necessary) per individual. Both exams must be taken by May 31, 2009.

The Exam Offer Voucher Code may not be combined with other vouchers or discounts and are void if altered or revised in any way.

Refer to http://learnandcertify.com/Terms.aspx for complete Terms & Conditions of Exam Voucher usage.