Click here to Skip to main content
14,427,818 members
Rate this:
Please Sign up or sign in to vote.
How to do rebuilding of indexes in a DB in a scheduled manner in Sql server 2005?
Any Inbuilt option there or whether an SP needed for the same. I want to do the same every week.
We are using asp.net with c#.
Posted

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

You need to create a procedure to do the rebuilding and a Job to execute the procedure as one of it's steps. There are a number of other maintenance operations you may want to include in the procedure.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100