http://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspxSPCQOptimizer Release Rss Descriptionhttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=10111Changes for this release &#58;<br /><br />&#42; Corrects bug where work tables were not created <br />&#42; Refactored optimizationProcedures <br />&#42; Removes UniqueID for content analysis<br />&#42; Adds float to analysis<br /><br /> <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Wed, 23 Jan 2008 11:08:10 GMTUPDATED RELEASE: Version 2 (Jan 23, 2008) 20080123110810Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=10111Changes for this release &#58;<br /><br />&#42; Corrects bug where work tables were not created <br />&#42; Refactored optimizationProcedures <br />&#42; Removes UniqueID for content analysis<br />&#42; Adds float to analysis<br /><br /> <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Wed, 23 Jan 2008 11:08:10 GMTRELEASED: Version 2 (Jan 23, 2008) 20080123110810Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=10111Changes for this release &#58;<br /><br />&#42; Corrects bug where work tables were not created <br />&#42; Refactored optimizationProcedures <br />&#42; Removes UniqueID for content analysis<br />&#42; Adds float to analysis<br /><br /><br />Install<br /><br />Create a work database on sharepoint sql server <br />Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure. <br />Examples<br /><br />To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />SPSFContentOptimize &#39;MossDev&#39;, &#39;Apples&#39;,&#39;&#39;,0 <br />To Scan with Trace to Detail what is being processed&#59; No Update<br />SPSFContentOptimize &#39;MossDev&#39;, &#39;Apples&#39;,&#39;&#39;,1 <br />To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; No Update<br />SPSFContentOptimize &#39;MossDev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0 <br />To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. No Update<br />SPSFContentOptimize&#93; &#39;MossDev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />To apply updates during run Updates&#33;&#33;<br />SPSFContentOptimize &#39;MossDev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39; <br /><br />Wed, 23 Jan 2008 11:07:36 GMTUPDATED RELEASE: Version 2 (Jan 23, 2008) 20080123110736Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=10111Changes for this release &#58;<br /><br />&#42; Corrects bug where work tables were not created <br />&#42; Refactored optimizationProcedures <br />&#42; Removes UniqueID for content analysis<br />&#42; Adds float to analysis<br /><br />Wed, 23 Jan 2008 11:06:50 GMTUPDATED RELEASE: Version 2 (Jan 23, 2008) 20080123110650Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=10111Changes for this release &#58;<br /><br />&#42; Corrects bug where work tables were not created <br />&#42; Refactored optimizationProcedures <br />&#42; Removes UniqueID for content analysis<br />&#42; Adds float to analysis<br /><br />Wed, 23 Jan 2008 11:05:45 GMTUPDATED RELEASE: Version 2 (Jan 23, 2008) 20080123110545Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Mon, 14 Jan 2008 09:50:20 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080114095020Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Dev Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Mon, 14 Jan 2008 09:49:23 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080114094923Ahttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:20:42 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113122042Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:20:13 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113122013Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed&#59; &#42;No Update&#42;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store&#59; &#42;No Update&#42;<br /><br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. &#42;No Update&#42;<br /><br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39; <br />&#42; To apply &#42;updates&#42; during run &#42;Updates&#33;&#33;&#42;<br /><br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:19:38 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121938Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed - No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; To apply &#42;updates&#42; during run <br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#42;&#64;Update&#61;&#39;Update&#39;&#42;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:17:50 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121750Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781 <br />&#42;Install&#42;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42;Examples&#42;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed - No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; To apply updates during run <br />&#42;&#42;SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:16:26 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121626Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 Release. <br />&#34;Install&#34;<br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#34;Examples&#34;<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed - No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; To apply updates during run <br />&#42;&#42;SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:15:38 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121538Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 Release. <br /><br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br /><br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed - No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br /><br />&#42; To Scan DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;orp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; To apply updates during run <br />&#42;&#42;SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:14:12 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121412Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 Release. <br /><br />&#35; Create a work database on sharepoint sql server <br />&#35; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br /><br />&#42; To Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; To Scan with Trace to Detail what is being processed - No Update<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br />&#42; Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br /><br />&#42; Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;orp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; Apply updates during run <br />&#42;&#42;SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:13:23 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121323Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 Release. <br />Install.<br />&#42; Create a work database on sharepoint sql server <br />&#42; Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br />&#42; <br /><br />&#42; Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39;<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,0<br />&#42; With Trace<br />&#42;&#42; SPSF_ContentOptimize &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1<br /><br />&#42; Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Apples&#39; that was created at url Corp&#47;Dept&#47;Store<br />&#91;SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;Corp&#47;Dept&#47;Store&#39;,0<br /><br />&#42; Scans DataBase Moss_Main Root Web For Content Errors for content type &#39;Page&#39; that was created at base &#39;&#39; url using &#39;Pages&#39; list located at &#39;Corp&#47;Dept&#39; as the master list template- Any Lists will not be corrected directly but data will be saved and SQL genertated for review. <br />&#42;&#42; SF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Page&#39;,&#39;&#39;,1,&#39;orp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;PrintUpdateSQLOnly&#39;<br />&#42; Apply updates during run <br />&#42;&#42;&#91;SPSF_ContentOptimize&#93; &#39;Moss_Dev&#39;, &#39;Apples&#39;,&#39;&#39;,1,&#39;Corp&#47;Dept&#39;,&#39;Pages&#39;,&#64;Update&#61;&#39;Update&#39;<br /><br /><br />.<br />Sun, 13 Jan 2008 12:10:57 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113121057Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 Release. <br />Install.<br />Create a work database on sharepoint sql server <br />Open the .QRY file in SQL 2005 Manager in the work database and compile the procedure.<br /><br />. <br />Sun, 13 Jan 2008 12:01:53 GMTUPDATED RELEASE: Version 1 (Jan 10, 2008) 20080113120153Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9781Version 1 ReleaseThu, 10 Jan 2008 15:32:37 GMTCREATED RELEASE: Version 1 (Jan 10, 2008) 20080110033237Phttp://www.codeplex.com/SPCQOptimizer/Release/ProjectReleases.aspx?ReleaseId=9769Version 1 Release Thu, 10 Jan 2008 02:14:03 GMTUPDATED RELEASE: Version 1 20080110021403A