Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Apollois
Starting Member
49 Posts |
 Posted - 2004-08-04 : 19:50:05
|
| I want to create indexes on computed columns in SS2K SP3a.According to the BOL, the following CONFIGURATION OPTIONS must be set as follows:====================================These options must be set to ON: ANSI_NULLS ANSI_PADDING ANSI_WARNINGS ARITHABORT CONCAT_NULL_YIELDS_NULL QUOTED_IDENTIFIER These options must be set to OFF: NUMERIC_ROUNDABORT====================================Is there any problem, or downside, to using the sp_dboption to set all these options for my database?TIA.Best Regards,Jim |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-08-04 : 20:06:11
|
| not really. I would also set them up in my Query Analyzer for all the developer PCs. Go to Tools/Options and set them for the connection options.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Indexes on Computed Columns