From: Erland Sommarskog on
fniles (fniles(a)pfmail.com) writes:
> Aha, you got it.
> I added column Symbol to the index, and column Symbol is a computed column
> with the following specification: (rtrim([CommodityCode]) + [MonthYear])
>
> So, if the database is in SQL 2005, I will not need to "SET ARITHABORT ON"
> ?

Correct.

(There still some situations in SQL 2005 where you need to have ARITHABORT
ON, to wit when you work with the xml data type. But for indexed views and
indexed computed columns ARITHABORT does not matter.)

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
First  |  Prev  | 
Pages: 1 2
Prev: running total column help
Next: set ARITHABORT on