InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:20:24 GMT20http://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxOxygen thank you for the post your code got me 80 % of the way there. I modified your cursor to look for PK in the db that are non clustered then rebuild as clustered. I found 32 in first db looked. isn't rolling on to a new company great? SELECT tc.TABLE_NAME, tc.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc inner join sys.indexes i on tc.CONSTRAINT_NAME= i.name where CONSTRAINT_TYPE = 'PRIMARY KEY' and i.index_id &lt;&gt; 1 ORDER BY TABLE_NAMEThu, 17 Mar 2011 13:13:04 GMTMudLuckhttp://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxFirst thing which is already mentioned that, its not working properly as it dealing FK as PK too, and second thing, what if, i have more then one filegroups ???Thu, 23 Jul 2009 04:37:46 GMTlionofdezerthttp://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxAdd: where CONSTRAINT_TYPE = 'PRIMARY KEY'to avoid scripting out the foreign keys.Tue, 12 May 2009 13:26:32 GMTGordo-174357http://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxi fixed the problem by SELECT TABLE_NAME, CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS WHERE CONSTRAINT_NAME LIKE '%PK%' --adding this line ORDER BY TABLE_NAMEand it worked for me since i have all my primary keys starting with PK_ :DFri, 30 Jan 2009 07:24:59 GMTDBA-640728http://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxIt appears to be not handling foreign keys properly and scripting them up as Primary keys.Fri, 22 Aug 2008 07:26:45 GMTPuttshttp://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxYou can script the Fill Factor too :Neat the end, just after : [code]SET @PKSQL = @PKSQL + ')'[/code] Add : [code]DECLARE @ff TinyIntSELECT @ff = (select A.fill_factor FROM sys.indexes A Where A.name=@PkName)SET @PKSQL = @PKSQL + ' WITH FILLFACTOR= ' + CAST(@ff as NVARCHAR)[/code]Thu, 15 May 2008 01:34:00 GMTDumas Jean Christophehttp://www.sqlservercentral.com/Forums/Topic404359-562-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Index+Management/31892/">SQL Server 2005: Script all Primary Keys</A>[/B]Sat, 29 Sep 2007 06:09:30 GMTOxygen