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

[jesper.joergensen]

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

Hidden in the development menu you will find a form "SYSSQLSetup" Use this to change the settings for the filegroups. Then Axapta will also use the settings doing the synchronization. /Jesper     Original Message        processed by Tobit InfoCenter  Subject:  RE: [development-axapta] How to change the filegroups of all the indexes of all tables (29-Jan-2004 11:58) From:     [EMAIL PROTECTED] To:       [EMAIL PROTECTED]   Hi Herbert!   Thanks for your suggestion. I think your reason is right. I will save my man/days by not to do it :D. Maybe I will try it some other time. I'll let you know the result (IA).   Thank you, Arief   -----Original Message----- From: Mister L [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 28, 2004 9:36 PM To: [EMAIL PROTECTED] Subject: AW: [development-axapta] 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:07 An: '[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. 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 Sponsor ADVERTISEMENT 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.