How to rebuild all indexes in SQL DB

Experts,

Is there a way to rebuild all indexes for a DB using a sql script. I am not able to build a maintenance plan, due to permission restrictions.
aijrealAsked:
Who is Participating?
 
dba2dbaCommented:
0
 
arnoldCommented:
http://blogs.msdn.com/b/joaol/archive/2008/01/28/script-to-rebuild-and-reorganize-database-indexes-sql-server-2005.aspx

Builds and process a rebuild or reorganize of an index based on fragmentation level.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.