Even though this thread is over 2 years old, for those who happen to stumble into it, this might help. Full snapshot backups taken by DPM (System Center) do not...

As mentioned earlier, the scope_identity function has been...

Ajit, I'm more curious about how you scheduled your diagnostic procedure to run and find the blocks. I've copied and run it, but it found nothing, because I don't...

nycgags (3/22/2013)

---

peter.row (2/24/2011)

---

Why use the output syntax, table variable and dynamic sql?

Wouldn't the following be simpler (no permissions issue on table if user running it only has access to SP...

Solomon Rutzky (2/26/2011)

---

Ajit, this is an interesting approach to the problem, but most likely it is just adding complication via over-engineering when a much simpler solution appears to be available.

1)...

Thanks to everyone who's viewed my article, and especially to those who've commented on the discussion board. Its great to see ideas flowing, and I've certainly learnt from them.

Its 11.30...

arturmariojr (2/24/2011)

---

But now you will have as many tables as you have keys in original table and, for each increment on some key, you will add a new register in...

In the application, there wasn't just one key. There were a few, and there were plans to put in many...

stephen.lear (2/24/2011)

---

Does your solution really solve the issue?

What if the requirement was for no gaps in the key sequence? Doesn't using identities in this way lead to gaps in the...

adam.everett (2/24/2011)

---

nice, good article never thought about how your could use vertical tables to solve that, and will also go and look at sequences in the next sql release!.

Can I...