Exactly, aggregate functions are deterministic. So they are allowed in indexed view. "Correct" answer is incorrect! 🙂

Deterministic and Nondeterministic Functions:

http://msdn.microsoft.com/en-us/library/ms178091.aspx

Hi,

I have exactly the same problem. Couldn't find any solution except this post...

Removing BEGIN/COMMIT/ROLLBACK TRAN really helps. But this is not a good solution 🙁