Wrox Programmer Forums
|
BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio
This is the forum to discuss the Wrox book ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solution by Vincent Varallo; ISBN: 9780470396865
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: ASP.NET 3.5 Enterprise Application Development with Visual Studio 2008: Problem Design Solutio section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 10th, 2009, 08:17 AM
Registered User
 
Join Date: Jul 2009
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Ch 6: Unique Key Constraint Violation

Hey All,

I am having problems adding users to existing roles. I can create a new role and add users to that role without problems. The problems arises when I try to add a user to an existing role. I get the following error when I try:

System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_RoleCapability'. Cannot insert duplicate key in object 'dbo.ENTRoleCapability'.

Am I doing something wrong? Any help is appreciated.

Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Violation of PRIMARY KEY constraint??? twyce C# 1 September 9th, 2008 01:23 AM
Why not using a unique constraint in ch 5? asptwodev BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 2 September 20th, 2007 09:25 AM
Insert Record Fails W/ Unique Constraint snw C# 0 September 2nd, 2005 02:14 PM
primary key violation muralikeane Classic ASP Databases 8 May 21st, 2004 09:24 PM
duplicate nulls in a column with unique constraint defiant SQL Server 2000 3 October 22nd, 2003 01:58 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.