Good question and explanation.

Interesting question that required googling skills.

+1

OCTom (4/24/2012)

---

sqlmunkee (4/24/2012)

---

So, the key bit here is that SQL will *decide* whether the sequence is ascending or descending based on the INCREMENT BY argument. That's a bit misleading if...

Thanks, made me laugh. 🙂

Schadenfreude-Mei (4/17/2012)

---

Sorry guys but I took a guess, got it wrong so ran it through my local 2k8r2 and get the below:

Msg 343, Level 15, State 1, Line 1

Unknown object...

jfogel (4/17/2012)

---

Got it right. It is nice to see the sequence feature is now in SQL Server. Mainly because developers had to use a sequence for Oracle and an identity...

L' Eomot Inversé (4/13/2012)

---

Hugo Kornelis (4/13/2012)

---

So I decided to test it. Here...

Steve Jones - SSC Editor (4/12/2012)

---

Hugo took the words out of my mouth. It's mainly for HA stuff, or potentially in the future, movement of dbs to new hosts without...

Hugo Kornelis (4/12/2012)

---

You...

Steve Jones - SSC Editor (4/12/2012)

---

Cliff Jones (4/12/2012)

---

Steve Jones - SSC Editor (4/12/2012)

---

The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication...

Steve Jones - SSC Editor (4/12/2012)

---

The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense....

Yes, I believe so. A good question none the less.

Good question. This is a useful feature of which I wasn’t aware.

GSquared (3/21/2012)

---

Hugo Kornelis (3/21/2012)

---

Yes, as GSquared already shows.

However, there are (as far as...