Just wanted to throw this out there. If you look in sys.sql_modules, only the definition for the 1st version of stored procedure is reported. This was bugging me a bit...

IceDread (5/25/2012)

---

The singular best sci fi movie I have seen as of late is Troll Hunter. http://www.imdb.com/title/tt1740707/

The start of the movie is a little unusual but it gets...

Hugo Kornelis (2/13/2012)

---

Revenant (2/13/2012)

---

All exactly as I expected. This confirms that on editions below Enterprise, the only way to get the optimizer to use an index on the view is...

Hugo Kornelis (2/13/2012)

---

jascunce (2/13/2012)

---

The same results...

Revenant (2/13/2012)

---

Hugo Kornelis (2/13/2012)

---

Toreador (2/13/2012)

---

On Enterprise edition the results are the same - the view index is used.

On both this and Developer edition I get a warning for each statement

"Warning:...