AW: [development-axapta] How to change the filegroups of all the indexes of all tables

[Mister L]

Title: How to change the filegroups of all the indexes of all tables





Hi 
Arief!
 
I 
don't think, it's a good idea changing the filegroups. I think, that after your 
first synchronize you will lose your settings.
 
But 
if you have success, I would be very interested :-)
 
regards
Herbert

  -----Ursprüngliche Nachricht-----Von: Arief Tarmizi 
  [mailto:[EMAIL PROTECTED]Gesendet: Dienstag, 27. Jänner 
  2004 13:07An: 
  '[EMAIL PROTECTED]'Betreff: [development-axapta] 
  How to change the filegroups of all the indexes of all 
  tables
  Hi All, 
  I need your suggestions. I want to tune up my axapta sql 
  server database. I want to separate the indexes and the data into different 
  filegroups. Currently, in SQL Server Enterprise Manager, i have to change all 
  the indexes in each table, which means i have to click one by one of each 
  table and change the index in order to change the filegroups.
  Is there anyway to change all of the indexes in simpler way 
  e.g. script or something, or tools etc. 
  Or maybe you can tell me which index of tables should I move ? 
  so I don't need to change all the table's indexes. 
  Or maybe is there any way to set the filegroups of the indexes 
  when we install axapta in the first place ? 
  Thank's 
  
  Yahoo! Groups Links
  
    To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/  

    To unsubscribe from this group, send an email to:[EMAIL PROTECTED]  

    Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 
  




Yahoo! Groups Links

To visit your group on the web, go to:http://groups.yahoo.com/group/development-axapta/ 
To unsubscribe from this group, send an email to:[EMAIL PROTECTED] 
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.