eshulman (3/28/2012)

---

Yes, we were going to try SCOPE_IDENTITY but sounds like that will not make any difference since we see gaps.

ALso was going to try the trace again - it...

drew.georgopulos (3/28/2012)

---

a candidate key is an attribute or attributes that do not have more than one row in a relation. a primary key is the chosen candidate key that dovetails...

Is this a custom extended stored procedure: xpLog_Info?

Barking up the wrong tree with me. I haven't learned PowerShell yet.

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 gets incremented.

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 and they...

SQLKnowItAll (3/28/2012)

---

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...

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 another table...

Adam Seniuk (3/28/2012)

---

Reply to MysteryJimbo

Break as in the LSN is now out of sync so it won't restore the log shipping on the secondary server.

Here is the error: Skipping log...

eshulman (3/28/2012)

---

The insert is done with an INSERT statement immediately followed by SELECT @@IDENTITY. Since it is a rare occurence (about 10 times per day) our theory has been...

Adam Seniuk (3/28/2012)

---

Reply to SS999

SQL 2008 R2 Enterprise

Well what we are noticing is that log shipping will fail after a differental backup and then we have to do a backup...

If what you are asking is will running a differential backup break the log chain for log shipping, the answer is no.

From Books Online.

When transaction safety is set to OFF, the session operates asynchronously. Asynchronous operation supports only one operating mode—high-performance mode. This mode enhances performance at the expense of high...

May I ask an academic question of the OP (that I am pretty sure I know the answer to)?

Please define a candidate key and a primary key.

patrickmcginnis59 (3/28/2012)

---

GilaMonster (3/28/2012)

---

patrickmcginnis59 (3/28/2012)

---

Ninja's_RGR'us (11/23/2011)

---

The most prolific poster post because it's the RIGHT thing to do. Not to get anything...