I believe it's better to have the DBA include this in the MSSQL maintenance plan. Varden Morris
276 Taralake Terrace N.E. Calgary, Alberta T3J 0A1 Canada (403) 366-8434 (H) (403) 615-1604 (C) [EMAIL PROTECTED] ----- Original Message ---- From: Sumit Loya <[EMAIL PROTECTED]> To: Axapta-Knowledge-Village@yahoogroups.com Sent: Monday, May 19, 2008 1:47:10 AM Subject: Re: [Axapta-Knowledge-Village] Setting Reindexing as a batch process Hi, I have a small code with which you can create a batch class and schedule it for batch run. Below is the piece of code: SqlDataDictionary sqlDict = new SqlDataDictionary( ); ; new SqlDataDictionaryPe rmission( methodstr( SqlDataDictionar y, tableReindex) ).assert( ); sqlDict.tableReinde x(); CodeAccessPermissio n::revertAssert( ); Ensure that you run the code on server otherwise the SqlDataDictionaryPe rmission will fail. Hope this is of some help to you. Regards, Sumit On Sat, May 17, 2008 at 9:02 AM, Satish <satishdalal@ gmail.com> wrote: Hi All, Would appreciate any pointers to setup reindexing (Administration | Periodic | SQL Administration | Index Actions > Reindex) as a batch process in AX? Also what would be a optimal schedule for reindexing the tables? I was thinking of a daily reindex of all the tables. Looking forward to any views, comments, pointers... Thanks, Satish