Sabka Dost....... India Post...... DISCLAIMER CERTIFICATE - All the information on this website is published in good faith and for general information purpose only. We do not make any warranties about the completeness, reliability and accuracy of this information. Any action you take upon the information on our website is strictly at your own risk. And we will not be liable for any losses and damages in connection with the use of our website. From our website, you can visit other websites by following hyperlinks to these sites. While we strive to provide only links to useful and ethical websites, we have no control over the content and nature of these sites and the links to other websites do not imply a recommendation for all the content found on these sites. Please be also aware that when you leave our website, other sites may have different privacy policies

Wednesday, September 7, 2011

Error while updating Office master of RNet in SQL 2008

While executing the office master query in Query Analyzer for RNet Office Master updation, the query is completed with the following error:
"Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_Office_Master'. Cannot insert duplicate key in object 'dbo.Office_Master'.The statement has been terminated."

Solution:
Run the attached exl file through scripttool.exe

Download
Posted by at