Error in transaction | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error in transaction

Hello, I have an application in vb. The problem that I have is, when I execute a couple sql command in a transaction
where by incident I have the primary keys double, that I don’t get an error in VB. fe Custid Custcode
1 A
1 B How can I solve this problem. Thanks Ralph
solution is smiple, Add primarykey constraint to the table.

what is the error you are getting —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

Ralph,<br /> I think it’s better to follow up what you post in this forum. Looks like there is no follow up from you to the posted responses/questions by other forum members. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br /><pre id="code"><font face="courier" size="2" id="code"><br />Thanks,<br /><br />Name<br />——— <br />Dilli Grg <br /><br />(1 row(s) affected)<br /></font id="code"></pre id="code">