I was create a simple select command to retrieving all record from a database table. But i am getting the error message \[code\]Error : Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.\[/code\]My table column have some lengthy record. I set the datatype for that column is varchar(2000).The above mentioned column record is given below\[code\]Accounts Officer|Admin Executive|Application Support Engineer|Asst Team Lead|HR Executive|IT|IT INFRASTRUCTURE|Jr Software Developer|Jr.Quality Analyst|Jr.Trainer|MIS-Executive|Network Administrator|Network Engineer|Nodal Executive|Process Lead|Process Mentor|Quality Analyst|Quality Executive|Sales Co-Ordinator|Software Developer|Sr. CSE|Sr. Team Leader|SYSTEM ADMINISTRATOR|Team Leader|Technical Support Executive|Trainer|WFM Executive|Buddy Team Lead|Executive-IT Commercial|Process Associate-Billing|Jr. MIS Executive|Desktop Engineer|Asst - HR|Lead - Quality|Lead - Training|\[/code\]Am using the below code to retrieve the data from database using dataset. Now i store the minimum value means it works fine.\[code\] DataSet7TableAdapters.sp_get_all_trv_mapdesigTableAdapter TA = new DataSet7TableAdapters.sp_get_all_trv_mapdesigTableAdapter(); DataSet7.sp_get_all_trv_mapdesigDataTable DS = TA.GetData(); if (DS.Rows.Count > 0) { }\[/code\]And also i changed the datatype as text. The same error occurred. Please help me to solve this issue.\[code\]DROP PROCEDURE IF EXISTS sunhrm.sp_get_all_trv_mapdesig;CREATE PROCEDURE sunhrm.`sp_get_all_trv_mapdesig`()Begin Start Transaction; Select * from tbl_trv_map_desig; commit; end;\[/code\]