InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:20:15 GMT20http://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxI really like it. With a little tweaking, I'm sure it could be coded to detect an existing filegroup on any of the indexes and insert them automatically in the output code. I work with several databases that have only some indexes in a file group, and others not.Thanks for sharing,--RichardFri, 23 Sep 2011 12:59:20 GMTThe Learnerhttp://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxSean, the ?'s appear during copy/paste operations for some code. The easiest solution is the perform a Find/Replace on the ?'s and replace them with spaces. If you editor supports it, you can take 4 ?'s and replace them with a tab.Fri, 23 Sep 2011 06:34:54 GMTtskelleyhttp://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxAndrew-This does not add indexes to all columns. Where did you get that idea?? What were you reading? There is no blindly adding here!!!!Fri, 10 Apr 2009 16:37:30 GMTGary L. Fry-196295http://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxI think this is some nice code. However, my cut/paste experience lead to many format problems. I had a bunch of ? marks after pasting this code into text pad. I think the formatting caused some of these problems. I was able to fix this by doing a find and replace operation.Thanks Again. Good ideas.Mon, 25 Aug 2008 05:41:02 GMTSean Woehrlehttp://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxWhy would you even think up the need for a script like this? Would you really blindly add indexes to every column on every table?Mon, 25 Aug 2008 05:00:17 GMTAndrew Kellyhttp://www.sqlservercentral.com/Forums/Topic529663-1326-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Indexes/63620/">Generate Create All Secondary Indexes For Entire Database</A>[/B]Mon, 07 Jul 2008 15:18:02 GMTGary L. Fry-196295