Timeline for How to find out what is causing my Identity column to keep going up
Current License: CC BY-SA 3.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Feb 28, 2012 at 20:49 | history | tweeted | twitter.com/#!/StackDBAs/status/174597114087743488 | ||
| Feb 28, 2012 at 20:43 | vote | accept | Nate | ||
| Feb 28, 2012 at 19:54 | history | edited | Leigh Riffel | CC BY-SA 3.0 |
Cleand up unecessary language, fixed typo, added commas, and clarified implication.
|
| Feb 28, 2012 at 19:45 | answer | added | Eric Higgins | timeline score: 7 | |
| Feb 28, 2012 at 19:41 | answer | added | ErikE | timeline score: 2 | |
| Feb 28, 2012 at 19:41 | comment | added | Eric Higgins | Thanks JNK, that confirms it then. I'll make an answer with some profiler info. | |
| Feb 28, 2012 at 19:38 | comment | added | JNK | It definitely does increment even on a rollback. Just tested in SS2008r2 | |
| Feb 28, 2012 at 19:34 | comment | added | Nate | Any suggestions on how to go about doing that? Is there a report or logging I can turn on? | |
| Feb 28, 2012 at 19:25 | comment | added | Eric Higgins | Interesting prob. How about transactions that ultimately rollback? Just a thought since I'm not sure that an uncommitted tran would bump the seed. I'd profile it :) | |
| Feb 28, 2012 at 19:11 | comment | added | Nate | My idea being that if I can find out the query causing the identity to increment, I can identify the application based on the nature of the query. | |
| Feb 28, 2012 at 19:10 | history | asked | Nate | CC BY-SA 3.0 |