select row_number() over (order by type)

from sys.objects

You can't beat a good solid RDBMS! 😀

adrian.facio (11/26/2013)

---

taqveem45 (11/26/2013)

---

nbraasch (11/26/2013)

---

from the example, if I'm not mistaken, the statements that are being rolled back are direct inserts to the table, but the index on the view is...

nbraasch (11/26/2013)

---

from the example, if I'm not mistaken, the statements that are being rolled back are direct inserts to the table, but the index on the view is what is...

No, it just means that the underlying table definition cannot be altered without removing the schema-binding dependency first. You can still create views without schema-binding. Any modifications to the...

A beautifully elegant solution to the problem.

From my 5 years experience, what I have realised is that it's not necessarily about whether they know the language in use, in this case T-SQL, but whether they know...