VS2008 has many varieties. BIDS is essentially VS2008, but the "version" that comes with SQL Server; i.e. you don't code C# or asp.net with it. So, when you create an...

eshulman (3/28/2012)

---

We will print out the insert statement in the case where the insert fails and we prompt the operator to save again (we still are inside our code and...

Its clear that the VB.NET code is assuming it will NOT be the same each time. So, (not being accusatory but asking a genuine question) how do you know for...

Hmm... Then why is the INSERT INTO table (column, columnb, columnn) VALUES( portion...

I would think there would be a uniquely generated prescription_id for each entry. That makes logical sense to me. Hence, the same person could have 2 of the same...

eshulman (3/28/2012)

---

Possible, we will try that although anytime we submit SQL statements with compilation errors in them we get them logged in our log and we fixed all of those...

Well... My best educated guess is that an invalid insert statement is being built and passed in the ones that are failing. I would write something into the VB.NET code...

Lowell (3/28/2012)

---

how about adding another server side trace that captures all errors and warnings , and limit it to just the database in question.

http://support.microsoft.com/kb/199037

then you might see that some basic...

Ok, let's say you are trying to identify this. You do a SELECT DISTINCT ColumnA, ColumnB and compare it with the number of rows in the table. They...

Lynn Pettis (3/28/2012)

---

If there are any check constraints that may have been violated (my testing had that reported to SSMS), the @@IDENTITY will return NULL and the indentity value still...

What suggestions?

1. Change @@identity to scope_identity()?...

Lynn Pettis (3/28/2012)

---

SQLKnowItAll (3/28/2012)

---

eshulman (3/28/2012)

---

We do not have any triggers on the table that we are having issues with. We also have researched the logged identity for "disappearing" records...

eshulman (3/28/2012)

---

We do not have any triggers on the table that we are having issues with. We also have researched the logged identity for "disappearing" records and they are...

Lynn Pettis (3/28/2012)

---

SQLKnowItAll (3/28/2012)

---

I would bet dollars to doughnuts that the insert ran just fine, but that another insert from another session ran between the insert and select, possibly on...

I would bet dollars to doughnuts that the insert ran just fine, but that another insert from another session ran between the insert and select, possibly on another table returning...