Creating an Indexed View

• Lookup_BI

  SSCrazy

  Points: 2964

  More actions

  March 20, 2008 at 10:18 am

  #204645

  All,

  I have a huge problem to solve.

  1) Need to create an Indexed View that joins multiple tables.I know how to create a regular View, but How do I create an Indexed View ?

  2)Need be able to replicate the Indexed View [above] across to another server B into a table.

  I have to get this done and seriously don't know where to start.

  Do HELP me out .Thank You.:crying:

  [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

• Mohan Kumar

  SSCertifiable

  Points: 5365

  More actions

  March 20, 2008 at 10:29 am

  #792111

  Please check this http://msdn2.microsoft.com/en-us/library/ms187864.aspx

  [font="Verdana"]--www.sqlvillage.com[/size][/font]