Rebldidx for ComputedColumn in SQL 2005

• To be a Competent DBA

  SSC Rookie

  Points: 47

  More actions

  October 19, 2007 at 4:50 pm

  #118971

  Hello,

  I have a scheduled job to rebuild index once a week in SQL 2000. Some of our tables are ComputedColumn..

  In SQL 2000, I am able to use xp_sqlmaint to rebuild index for computed comlumnds by specifying -SupportComputedColumn tag..

  ex) EXECUTE master.dbo.xp_sqlmaint N'-D "HRPROD89" -RebldIdx 10 -SupportComputedColumn'

  I would like to achive same thing with SQL 2005 ..How could I rebuild index for computed column in SQL 2005?

  sp_sqlmaint is not supported with SQL 2k5 any more..

  Any advice will be greatly appreciated!!

• Paul Randal

  One Orange Chip

  Points: 29544

  More actions

  October 22, 2007 at 1:11 pm

  #744224

  Why not just create a script to rebuild the index you're interested in and setup a weekly Agent job to run the script?

  Paul Randal
  CEO, SQLskills.com: Check out SQLskills online training!
  Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
  SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
  Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005