SET OPTIONS for index views

• bodhilove

  SSCarpal Tunnel

  Points: 4035

  More actions

  January 8, 2009 at 6:40 pm

  #217326

  I want to create an indexed view. to do this you need these set options

  SET NUMERIC_ROUNDABORT OFF;

  SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT,

  QUOTED_IDENTIFIER, ANSI_NULLS ON;

  aren't these options at the database scope and if so shouldn't they be set back to what they were originally after you have created the view?

• jagadishrashmi

  SSC-Addicted

  Points: 496

  More actions

  January 12, 2009 at 2:40 pm

  #925601

  The default config for various options is available

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

  It is best to reset to the original config after the work on index view is done

  ---- [font="Tahoma"]Live and Let Live![/font] ----