More servicesWindows Live
HomeHotmailSpacesOneCare
 
MSN
Sign in
 
 
Spaces home  SaurabhProfileFriendsBlogMore Tools Explore the Spaces community

Blog

    • View next 20 entriesView last 20 entries
    October 06

    SharePoint with Silverlight

    The Microsoft Software + Services Blueprint folks have been kind enough to build a blueprint for the use of Silverlight in SharePoint Web Parts. The Silverlight Blueprint for SharePoint is source code and guidance for developers describing how to use Microsoft Silverlight and Microsoft SharePoint Products and Technologies together in business applications and Internet web sites. SharePoint applications that use Web Parts can now be built using Silverlight user interface elements. This capability enables a fresh look at data exposed through SharePoint Products and Technologies using the modern graphics capability in Silverlight.

    For more information about samples that we’ve built that you can reuse, customize, or extend for your SharePoint web sites and for links to downloads and screencasts click here to go to the Silverlight Blueprint for SharePoint page on MSDN.

    Regards,
    Saurabh Dhall

    Download Silverlight

    Instructions on Silverlight Blueprint for SharePoint

    Official Web for Microsoft's Silverlight

    Following are the Steps for Sharepoint's Integartion with Silverlight.

    These pictures come from a SharePoint image library http://www.wssdemo.com/today but use a Data View web part to add each image to a SilverLight control.

    Based on an SPS 2003 web part from
    http://binaryjam.wordpress.com/2007/06/05/sharepoint-silverlight-image-library-viewer-part/

    The advantage of using the DVWP is that there is no code to be deployed to the SharePoint server, just a few files that can be uploaded to a document library.



    How to build the Silverlight web part

    Steps to create this on your own site using SharePoint Designer (no server access or web part installation required).

    Assuming you have a SharePoint picture library already created. Copy any code below into notepad first.

    1. Create a Document Library to hold your web part page and the required SilverLight files (set template to Web Part Page)
    2. Create a folder called script in the document library
    3. Copy the following files from http://www.codeplex.com/bjsspv/Release/ProjectReleases.aspx?ReleaseId=6444 into the script folder
      1. Createsilverlight.js
      2. Main.js
      3. Silverlight.js
      4. Scene.xaml
      5. Photoitem.xaml
    4. Create a Web Part Page in the library
    5. Edit the web part page in SharePoint Designer
    6. Insert a Data View of your picture Library (just select one field from the data source view)
    7. Set the data view layout to Plain Layout
    8. Add the following code immediately before the <xsl:call-template name="dvt_1"/> tag in the <xsl:template match="/" section.

      <xsl:text disable-output-escaping="yes"><![CDATA[<script type="text/javascript" src="script/CreateSilverlight.js"></script>
          <script type="text/javascript" src="script/Silverlight.js"></script>
          <script type="text/javascript" src="script/Main.js"></script>
          <div id="SilverlightControlHost">Loading...<script type="text/javascript">
              var localScene=new BinaryJamSFSPart.Scene('SilverlightControlHost', 'script');
              createSilverlight('SilverlightControlHost', 'script/Scene.xaml', 'SilverlightControl','640','520', localScene);
          </script>]]></xsl:text>

    9. Replace the dvt_1 template with the following

              <xsl:template name="dvt_1">
                  <xsl:variable name="dvt_StyleName">PlnTitl</xsl:variable>
                  <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row" />
                  <xsl:text disable-output-escaping="yes"><![CDATA[<script type="text/javascript">
                  ]]></xsl:text>
                  <xsl:call-template name="dvt_1.body">
                      <xsl:with-param name="Rows" select="$Rows" />
                  </xsl:call-template>
                  <xsl:text disable-output-escaping="yes"><![CDATA[</script></div>]]></xsl:text>
              </xsl:template>

    10. Replace all the code between the <xsl:template name="dvt_1.rowview"> </xsl:template> with

      localScene.PhotoItemsUrls['<xsl:value-of select="position()-1"/>'] =  new BinaryJamSFSPartPhotoUrls('http://www.wssdemo.com<xsl:value-of select="@FileRef"/>','http://www.wssdemo.com/today/_t/<xsl:value-of select="substring-before(@LinkFilenameNoMenu,'.')" />_<xsl:value-of select="substring-after(@LinkFilenameNoMenu,'.')" />.jpg');

      This adds the image url and calculates the thumbnail for the image (_ext.jpg). Substitute www.wssdemo.com with your site url and Today with your picture library.

    11. Save your page and view it in the browser (mouse over the bottom of the image to get the selector to display)

    Overview of XSL Template changes

    Logical XSL sections

    Tags: Microsoft Sharepoint WSS MOSS WPF Silverlight Beta Integartion Silverlight WebPart CodePlex Solution


    June 26

    MOSS Roll-up Continues...

    Guys,

    Following are the latest Roll-ups (as on June 1st 2008) for the WSS & MOSS SP1.

    WSS    12.0.6316.5000    KB953137
     
    WSS    12.0.6314.5000    KB952292

                         
    MOSS     12.0.6316.5000    KB953138

    Order - WSS SP1 > MOSS SP1 > 953137 > 952292 > 953138 

    953137
    Version Number always shows 0.0.0000.0
    Incremental crawl doesn't crawl items in meeting workspace template doc lib
    Display item forms for calendar do not open the corresponding items when using the calendar view link to go to the display form.
    filtering of this file ended becasue the file reached maximum limit.
    SP1 removes DCOM permissions for OSearch causing search to fail.


    952292
    Cannot open menu on items in picture library with workflow enabled.

    953138
    Tools menu is available but no response if select any item when About is opened  
    MOSS12 - Property Import Mapping for "Name/Preferred Name" maps despite being unmapped  
    Thumbnails in the image library do not display in extranet publishing scenario  
    CMS12 - Custom dictionaries don't work with extended characters  
    SRCH12 - Filtering of this file ended because the file reached max limit  
    MOSS: Image GET failing for team sites when blob cached enabled  
    MOSS: Cannot delete last navigation item on subsites that don't inherit top link bar from parent  
    SRCH12 - SP1 removes DCOM permissions for OSearch causing search to fail  
    Users are able to publish pages without required fields after navigating back to the unpublished page.  
    Ability to navigate away from page without data saved  

    MOSS Version Details:-

    MOSS 20071 or WSS 3.0 post-SP1 hotfix (KB948945)               12.0.0.6303

        MOSS 20071 or WSS 3.0 post-SP1 hotfix (KB941274)           12.0.0.6301

        MOSS 20071 or WSS 3.0 post-SP1 hotfix (KB941422)           12.0.0.6300

        MOSS 20071 or WSS 3.0 SP1                                                     12.0.0.6219

        MOSS 20071 or WSS 3.0 October public update                    12.0.0.6039

        MOSS 20071 or WSS 3.0 August 24, 2007 hotfix package    12.0.0.6036

        MOSS 20071 or WSS 3.0 RTM                                                  12.0.0.4518

        MOSS 20071 or WSS 3.0 Beta 2 TR:                                         12.0.0.4407

        MOSS 20071 or WSS 3.0 Beta 2:                                               12.0.0.4017

        Office 12 (PDC image - pre-beta):                                              12.0.0.3111 (This version of Office does not have a support link in the Add/Remove programs dialog box).

    Regards,
    Saurabh


    Tags: 953138, 952292, 953137, kb953138, kb952292, kb953137, "MOSS SP1 Rollup", MOSS, SP1, Rollup, Roll-up, Roll, up, "content deployment", techacid




    June 23

    STSADM

    Thanks to Jose for sharing these details.

    1. stsadm -o activatefeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-url <url>] [-force]
    2. stsadm -o activateformtemplate -url <URL to the site collection> [-formid <form template ID>] [-filename <path to form template file>]
    3. stsadm -o addalternatedomain -url <protocol://existing.WebApplication.URLdomain> -incomingurl <protocol://incoming.url.domain> -urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web application resource name>
    4. stsadm -o addcontentdb -url <url> -databasename <database name> [-databaseserver <database server name>] [-databaseuser <database username>] [-databasepassword <database password>] [-sitewarning <site warning count>] [-sitemax <site max count>]
    5. stsadm -o adddataconnectionfile -filename <path to file to add> [-webaccessible <bool>] [-overwrite <bool>] [-category <bool>]
    6. stsadm -o add-ecsfiletrustedlocation -Ssp <SSP name> -Location <URL|UNC> -LocationType SharePoint|Unc|Http -IncludeChildren True|False [-SessionTimeout <time in seconds>] [-ShortSessionTimeout <time in seconds>] [-MaxRequestDuration <time in seconds>] [-MaxWorkbookSize <file size in Mbytes>] [-MaxChartSize <size in Mbytes>] [-VolatileFunctionCacheLifetime <time in seconds>] [-DefaultWorkbookCalcMode File|Manual|Auto|AutoDataTables] [-AllowExternalData None|Dcl|DclAndEmbedded] [-WarnOnDataRefresh True|False] [-StopOpenOnRefreshFailure True|False] [-PeriodicCacheLifetime <time in seconds>] [-ManualCacheLifetime <time in seconds>] [-MaxConcurrentRequestsPerSession <number of requests>] [-AllowUdfs True|False] [-Description <descriptive text>]
    7. stsadm -o add-ecssafedataprovider -Ssp <SSP name> -ID <data provider id> -Type Oledb|Odbc|OdbcDsn [-Description <descriptive text>]
    8. stsadm -o add-ecstrusteddataconnectionlibrary -Ssp <SSP name> -Location <URL> [-Description <descriptive text>]
    9. stsadm -o add-ecsuserdefinedfunction -Ssp <SSP name> -Assembly <strong name|file path> -AssemblyLocation GAC|File [-Enable True|False] [-Description <descriptive text>]
    10. stsadm -o addexemptuseragent -name <user-agent to receive InfoPath files instead of a Web page>
    11. stsadm -o addpath -url <url> -type <explicitinclusion/wildcardinclusion>
    12. stsadm -o addpermissionpolicy -url <url> -userlogin <login name> -permissionlevel <permission policy level> [-zone <URL zone>] [-username <display name>]
    13. stsadm -o addsolution -filename <Solution filename> [-lcid <language>]
    14. stsadm -o addtemplate -filename <template filename> -title <template title> [-description <template description>]
    15. stsadm -o adduser -url <url> -userlogin <DOMAIN\user> -useremail <someone@example.com> -role <role name> / -group <group name> -username <display name> [-siteadmin]
    16. stsadm -o addwppack  -filename <Web Part Package filename> [-lcid <language>] [-url <url>] [-globalinstall] [-force] [-nodeploy]
    17. stsadm -o addwppack  -name <name of Web Part Package> [-lcid <language>] [-url <url>] [-globalinstall] [-force]
    18. stsadm -o addzoneurl -url <protocol://existing.WebApplication.URLdomain> -urlzone <default, extranet, internet, intranet, custom> -zonemappedurl <protocol://outgoing.url.domain> -resourcename <non-web application resource name>
    19. stsadm -o allowuserformwebserviceproxy -url <Url of the web application> -enable <true to enable, false to disable>
    20. stsadm -o allowwebserviceproxy -url <Url of the web application> -enable <true to enable, false to disable>
    21. stsadm -o associatewebapp -title <SSP name> [-default | -parent] -url <Web application 1 url,Web application 2 url> [-all]
    22. stsadm -o authentication -url <url> -type <windows/forms/websso> [-usebasic (valid only in windows authentication mode)] [-usewindowsintegrated (valid only in windows authentication mode)] [-exclusivelyusentlm (valid only in windows authentication mode)] [-membershipprovider <membership provider name>] [-rolemanager <role manager name>] [-enableclientintegration] [-allowanonymous]
    23. stsadm -o backup -url <url> -filename <filename> [-overwrite]
    24. stsadm -o backup -directory <UNC path> -backupmethod <full | differential> [-item <created path from tree>] [-percentage <integer between 1 and 100>] [-backupthreads <integer between 1 and 10>] [-showtree] [-quiet]
    25. stsadm -o backuphistory -directory <UNC path> [-backup] [-restore]
    26. stsadm -o binddrservice -servicename <data retrieval service name> -setting <data retrieval services setting>
    27. stsadm -o blockedfilelist -extension <extension> -add [-url <url>]
    28. stsadm -o blockedfilelist -extension <extension> -delete [-url <url>]
    29. stsadm -o canceldeployment -id <id>
    30. stsadm -o changepermissionpolicy -url <url> -userlogin <DOMAIN\name> [-zone <URL zone>] [-username <display name>] [{ -add | -delete } -permissionlevel <permission policy level>]
    31. stsadm -o copyappbincontent
    32. stsadm -o createadminvs [-admapidname <app pool name>] [-admapidtype <configurableid/NetworkService>] [-admapidlogin <DOMAIN\name>] [-admapidpwd <app pool password>]
    33. stsadm -o createcmsmigrationprofile -profilename <profile name> [-description <description>] [-connectionstring <connection string>] -databaseserver <server>  -databasename <name>  -databaseuser <username>  [-databasepassword <password>] [-auth windowsauth|sqlauth] -destination <url> [-rootchannel <channelname>] [-destinationlocale <LCID>] [-migrateresources onlyused|all] [-migrateacls yes|no] [-emailto <address1;address2>] [-emailon success|failure|none|both] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]
    34. stsadm -o creategroup -url <url> -name <group name> -description <description> -ownerlogin <DOMAIN\name or group name> [-type member|visitor|owner]
    35. stsadm -o createsite -url <url> -owneremail <someone@example.com> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <someone@example.com>] [-secondarylogin <DOMAIN\name>] [-secondaryname <display name>] [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-hostheaderwebapplicationurl <web application url>] [-quota <quota template>]
    36. stsadm -o createsiteinnewdb -url <url> -owneremail <someone@example.com> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <someone@example.com>] [-secondarylogin <DOMAIN\name>] [-secondaryname <display name>] [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-hostheaderwebapplicationurl <web application url>] [-quota <quota template>] [-databaseuser <database username>] [-databasepassword <database password>] [-databaseserver <database server name>] [-databasename <database name>]
    37. stsadm -o createssp -title <SSP name> -url <Web application url> -mysiteurl <MySite Web application url> -ssplogin <username> -indexserver <index server> -indexlocation <index file path> [-ssppassword <password>] [-sspdatabaseserver <SSP database server>] [-sspdatabasename <SSP database name>] [-sspsqlauthlogin <SQL username>] [-sspsqlauthpassword <SQL password>] [-searchdatabaseserver <search database server>] [-searchdatabasename <search database name>] [-searchsqlauthlogin <SQL username>] [-searchsqlauthpassword <SQL password>] [-ssl <yes|no>]
    38. stsadm -o createweb -url <url> [-lcid <language>] [-sitetemplate <site template>] [-title <site title>] [-description <site description>] [-convert] [-unique]
    39. stsadm -o databaserepair -url <url> -databasename <database name> [-deletecorruption]
    40. stsadm -o deactivatefeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-url <url>] [-force]
    41. stsadm -o deactivateformtemplate -url <URL to the site collection> [-formid <form template ID>] [-filename <path to form template file>]
    42. stsadm -o deleteadminvs
    43. stsadm -o deletealternatedomain -url <ignored> -incomingurl <protocol://incoming.url.domain>
    44. stsadm -o deletecmsmigrationprofile -profilename <profile name>
    45. stsadm -o deleteconfigdb
    46. stsadm -o deletecontentdb -url <url> -databasename <database name> [-databaseserver <database server name>]
    47. stsadm -o deletegroup -url <url> -name <group name>
    48. stsadm -o deletepath -url <url>
    49. stsadm -o deletepermissionpolicy -url <url> -userlogin <login name> [-zone <URL zone>]
    50. stsadm -o deletesite -url <url> -deleteadaccounts <true/false>
    51. stsadm -o deletesolution -name <Solution name> [-override] [-lcid <language>]
    52. stsadm -o deletessp -title <SSP name> [-deletedatabases]
    53. stsadm -o deletessptimerjob -title <SSP Name> -jobid <SSP Timer Job Id>
    54. stsadm -o deletetemplate -title <template title> [-lcid <language>]
    55. stsadm -o deleteuser -url <url> -userlogin <DOMAIN\name> [-group <group>]
    56. stsadm -o deleteweb -url <url>
    57. stsadm -o deletewppack -name <name of Web Part Package> [-lcid <language>] [-url <url>]
    58. stsadm -o deletezoneurl -url <protocol://existing.WebApplication.URLdomain> -urlzone <default, extranet, internet, intranet, custom> -resourcename <non-web application resource name>
    59. stsadm -o deploysolution -name <Solution name> [-url <virtual server url>] [-allcontenturls] [-time <time to deploy at>] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>] [-force]
    60. stsadm -o deploywppack -name <Web Part Package name> [-url <virtual server url>] [-time <time to deploy at>] [-immediate] [-local] [-lcid <language>] [-globalinstall] [-force]
    61. stsadm -o disablessc -url <url>
    62. stsadm -o displaysolution -name <Solution name>
    63. stsadm -o editcmsmigrationprofile -profilename <profile name> [-description <description>] [-connectionstring <connection string>] [-databaseserver <server>] [-databasename <name>] [-databaseuser <username>] [-databasepassword <password>] [-auth sqlauth|windowsauth] [-emailto <address1;address2>] [-emailon success|failure|none|both] [-excludeschema ] [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no]
    64. stsadm -o editcontentdeploymentpath -pathname <path name> [-keeptemporaryfiles Never|Always|Failure] [-enableeventreceivers yes|no] [-enablecompression yes|no]
    65. stsadm -o editssp -title <SSP name> [-newtitle <new SSP name>] [-sspadminsite <administration site url>] [-ssplogin <username>] [-ssppassword <password>] [-indexserver <index server>] [-indexlocation <index file path>] [-setaccounts <process accounts (domain\username)>] [-ssl <yes|no>]
    66. stsadm -o email -outsmtpserver <SMTP server> -fromaddress <someone@example.com> -replytoaddress <someone@example.com> -codepage <codepage> [-url <url>]
    67. stsadm -o enablecmsurlredirect -profilename <profile name> -off
    68. stsadm -o enablessc -url <url> [-requiresecondarycontact]
    69. stsadm -o enumalternatedomains -url <protocol://existing.WebApplication.URLdomain> -resourcename <non-web application resource name>
    70. stsadm -o enumcontentdbs -url <url>
    71. stsadm -o enumdataconnectionfiledependants -filename <filename for which to enumerate dependants>
    72. stsadm -o enumdataconnectionfiles [-mode <a | u | all | unreferenced>]
    73. stsadm -o enumdeployments
    74. stsadm -o enumexemptuseragents
    75. stsadm -o enumformtemplates
    76. stsadm -o enumgroups -url <url>
    77. stsadm -o enumroles -url <url>
    78. stsadm -o enumservices
    79. stsadm -o enumsites -url <virtual server url> -showlocks -redirectedsites
    80. stsadm -o enumsolutions
    81. stsadm -o enumssp -title <SSP name> [-default | -parent | -all]
    82. stsadm -o enumssptimerjobs -title <SSP Name>
    83. stsadm -o enumsubwebs -url <url>
    84. stsadm -o enumtemplates [-lcid <language>]
    85. stsadm -o enumusers -url <url>
    86. stsadm -o enumwppacks [-name <name of Web Part Package>] [-url <virtual server url>] [-farm]
    87. stsadm -o enumzoneurls -url <protocol://existing.WebApplication.URLdomain> -resourcename <non-web application resource name>
    88. stsadm -o execadmsvcjobs
    89. stsadm -o export -url <URL to be exported> -filename <export file name> [-overwrite] [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-versions <1-4> 1= Last major version for files and list items (default), 2= The current version, either the last major or the last minor, 3= Last major and last minor version for files and list items, 4= All versions for files and list items] [-cabsize <integer from 1-1024 megabytes> (default: 25)] [-nofilecompression] [-quiet]
    90. stsadm -o extendvs -url <url> -ownerlogin <domain\name> -owneremail <someone@example.com> [-exclusivelyusentlm] [-ownername <display name>] [-databaseuser <database user>] [-databaseserver <database server>] [-databasename <database name>] [-databasepassword <database user password>] [-lcid <language>] [-sitetemplate <site template>] [-donotcreatesite] [-description <iis web site name>] [-sethostheader] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous]
    91. stsadm -o extendvsinwebfarm -url <url> -vsname <web application name> [-exclusivelyusentlm] [-apidname <app pool name>] [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-allowanonymous]
    92. stsadm -o forcedeleteweb -url <url>
    93. stsadm -o formtemplatequiescestatus [-formid <form template ID>] [-filename <path to form template file>]
    94. stsadm -o getadminport
    95. stsadm -o getdataconnectionfileproperty -filename <filename of the data connection file> -pn <property name>
    96. stsadm -o getformsserviceproperty -pn <option name>
    97. stsadm -o getformtemplateproperty [-formid <form template ID>] [-filename <path to form template file>] -pn <property name>
    98. stsadm -o getproperty -propertyname <property name> [-url <url>] (SharePoint cluster properties: avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties: alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)
    99. stsadm -o getsitedirectoryscanschedule
    100. stsadm -o getsitelock -url <url>
    101. stsadm -o geturlzone -url <protocol://incoming.url.domain>
    102. stsadm -o import -url <URL to import to> -filename <import file name> [-includeusersecurity] [-haltonwarning] [-haltonfatalerror] [-nologfile] [-updateversions <1-3> 1= Add new versions to the current file (default), 2= Overwrite the file and all its versions (delete then insert),3= Ignore the file if it exists on the destination] [-nofilecompression] [-quiet]
    103. stsadm -o installfeature {-filename <relative path to Feature.xml from system feature directory> | -name <feature folder>} [-force]
    104. stsadm -o listlogginglevels [-showhidden]
    105. stsadm -o listregisteredsecuritytrimmers -ssp <ssp name>
    106. stsadm -o localupgradestatus
    107. stsadm -o managepermissionpolicylevel -url <url> -name <permission policy level name> [{ -add | -delete }] [-description <description>] [-siteadmin <true | false>] [-siteauditor <true | false>] [-grantpermissions <comma-separated list of permissions>] [-denypermissions <comma-separated list of permissions>]
    108. stsadm -o migrateuser -oldlogin <DOMAIN\name> -newlogin <DOMAIN\name> [-ignoresidhistory]
    109. stsadm -o osearch [-action <list|start|stop>] required parameters for 'start' (if not  already set): role, farmcontactemail, service credentials [-f (suppress prompts)] [-role <Index|Query|IndexQuery>] [-farmcontactemail <email>] [-farmperformancelevel <Reduced|PartlyReduced|Maximum>] [-farmserviceaccount <DOMAIN\name> (service credentials)] [-farmservicepassword <password>] [-defaultindexlocation <directory>] [-propagationlocation <directory>]
    110. stsadm -o osearchdiacriticsensitive -ssp <ssp name> [-setstatus <True|False>] [-noreset] [-force]
    111. stsadm -o preparetomove {-ContentDB <DatabaseServer:DatabaseName> | -Site <URL>} [-OldContentDB <uniqueidentifier>] [-undo]
    112. stsadm -o profilechangelog -title <SSP Name> -daysofhistory <number of days> -generateanniversaries
    113. stsadm -o profiledeletehandler -type <Full Assembly Path>
    114. stsadm -o provisionservice -action <start/stop> -servicetype <servicetype (namespace or assembly qualified name if not SharePoint service)> [-servicename <servicename>]
    115. stsadm -o quiescefarm -maxduration <duration in minutes>
    116. stsadm -o quiescefarmstatus
    117. stsadm -o quiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>] -maxduration <time in minutes>
    118. stsadm -o reconvertallformtemplates
    119. stsadm -o refreshdms -url <url>
    120. stsadm -o refreshsitedms -url <url>
    121. stsadm -o registersecuritytrimmer -ssp <ssp name> -id <0 - 2147483647> -typename <assembly qualified TypeName of ISecurityTrimmer implementation> -rulepath <crawl rule URL> [-configprops <name value pairs delimited by '~'>]
    122. stsadm -o registerwsswriter
    123. stsadm -o removedataconnectionfile -filename <filename to remove>
    124. stsadm -o removedrservice -servicename <data retrieval service name> -setting <data retrieval services setting>
    125. stsadm -o remove-ecsfiletrustedlocation -Ssp <SSP name> -Location <URL|UNC> -LocationType SharePoint|Unc|Http
    126. stsadm -o remove-ecssafedataprovider -Ssp <SSP name> -ID <data provider id> -Type Oledb|Odbc|OdbcDsn
    127. stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp <SSP name> -Location <URL>
    128. stsadm -o remove-ecsuserdefinedfunction -Ssp <SSP name> -Assembly <strong name|file path> -AssemblyLocation GAC|File
    129. stsadm -o removeexemptuseragent -name <user-agent to receive InfoPath files instead of a Web page>
    130. stsadm -o removeformtemplate [-formid <form template ID>] [-filename <path to form template file>]
    131. stsadm -o removesolutiondeploymentlock [-server <server> [-allservers]
    132. stsadm -o renameserver -oldservername <oldServerName> -newservername <newServerName>
    133. stsadm -o renameweb -url <url> -newname <new subsite name>
    134. stsadm -o restore -url <url> -filename <filename> [-hostheaderwebapplicationurl <web application url>] [-overwrite]
    135. stsadm -o restore -directory <UNC path> -restoremethod <overwrite | new> [-backupid <Id from backuphistory, see stsadm -help backuphistory>] [-item <created path from tree>] [-percentage <integer between 1 and 100>] [-showtree] [-suppressprompt] [-username <username>] [-password <password>] [-newdatabaseserver <new database server name>] [-quiet]
    136. stsadm -o restoressp -title <SSP name> -url <Web application url> -ssplogin <username> -mysiteurl <MySite Web application url> -indexserver <index server> -indexlocation <index file path> [-keepindex] -sspdatabaseserver <SSP database server> -sspdatabasename <SSP database name> [-ssppassword <password>] [-sspsqlauthlogin <SQL username>] [-sspsqlauthpassword <SQL password>] [-searchdatabaseserver <search database server>] [-searchdatabasename <search database name>] [-searchsqlauthlogin <SQL username>] [-searchsqlauthpassword <SQL password>] [-ssl <yes|no>]
    137. stsadm -o retractsolution -name <Solution name> [-url <virtual server url>] [-allcontenturls] [-time <time to remove at>] [-immediate] [-local] [-lcid <language>]
    138. stsadm -o retractwppack -name <Web Part Package name> [-url <virtual server url>] [-time <time to retract at>] [-immediate] [-local] [-lcid <language>]
    139. stsadm -o runcmsmigrationprofile -profilename <profile name> [-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime <DateTime string>] [-migrationfolder <path>] [-exportonly ] [-importonly ] [-htmldiff <path>]
    140. stsadm -o runcontentdeploymentjob -jobname <name> [-wait yes|no] [-deploysincetime <datetime>] (<datetime> as "MM/DD/YY HH:MM:SS")
    141. stsadm -o scanforfeatures [-solutionid <Id of Solution>] [-displayonly]
    142. stsadm -o setadminport -port <port> [-ssl] [-admapcreatenew] [-admapidname <app pool name>]
    143. stsadm -o setapppassword -password <password>
    144. stsadm -o setbulkworkflowtaskprocessingschedule -schedule <recurrence string>
    145. stsadm -o setconfigdb [-connect] -databaseserver <database server> [-databaseuser <database user>] [-databasepassword <database user password>] [-databasename <database name>] [-exclusivelyusentlm] [-farmuser] [-farmpassword] [-adcreation] [-addomain <Active Directory domain>] [-adou <Active Directory OU>]
    146. stsadm -o setcontentdeploymentjobschedule -jobname <name> -schedule <schedule> (Schedule Parameter Examples: "every 5 minutes between 0 and 59", "hourly between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00 and Sun 06:00:00", "monthly at 15 15:00:00", "yearly at Jan 1 15:00:00")
    147. stsadm -o setdataconnectionfileproperty -filename <filename of the data connection file> -pn <property name> -pv <property value>
    148. stsadm -o setdefaultssp -title <SSP name>
    149. stsadm -o set-ecsexternaldata -Ssp <SSP name> [-ConnectionLifetime <time in seconds>] [-UnattendedServiceAccountName <account name>] [-UnattendedServiceAccountPassword <account password>]
    150. stsadm -o set-ecsloadbalancing -Ssp <SSP name> [-Scheme WorkbookUrl|RoundRobin|Local] [-RetryInterval <time in seconds>]
    151. stsadm -o set-ecsmemoryutilization -Ssp <SSP name> [-MaxPrivateBytes <memory in MBytes>] [-MemoryCacheThreshold <percentage>] [-MaxUnusedObjectAge <time in minutes>]
    152. stsadm -o set-ecssecurity -Ssp <SSP name> [-FileAccessMethod UseImpersonation|UseFileAccessAccount] [-AccessModel Delegation|TrustedSubsystem] [-RequireEncryptedUserConnection False|True] [-AllowCrossDomainAccess True|False]
    153. stsadm -o set-ecssessionmanagement -Ssp <SSP name> [-MaxSessionsPerUser <number of sessions>]
    154. stsadm -o set-ecsworkbookcache -Ssp <SSP name> [-Location <local or UNC path>] [-MaxCacheSize <storage in Mbytes>] [-EnableCachingOfUnusedFiles True|False]
    155. stsadm -o setformsserviceproperty -pn <option name> -pv <option value>
    156. stsadm -o setformtemplateproperty [-formid <form template ID>] [-filename <path to form template file>] -pn <property name> -pv <property value>
    157. stsadm -o setholdschedule -schedule <recurrence string>
    158. stsadm -o setlogginglevel [-category < [CategoryName | Manager:CategoryName [;...]] >] {-default | -tracelevel  < None;  Unexpected; Monitorable; High; Medium; Verbose> [-windowslogginglevel < None;  ErrorServiceUnavailable;  ErrorSecurityBreach;  ErrorCritical;  Error;  Warning;  FailureAudit; SuccessAudit;  Information;  Success>] }
    159. stsadm -o setpolicyschedule -schedule <recurrence string>
    160. stsadm -o setproperty -propertyname <property name> -propertyvalue <property value> [-url <url>] (SharePoint cluster properties:, avallowdownload, avcleaningenabled, avdownloadscanenabled, avnumberofthreads, avtimeout, avuploadscanenabled, command-line-upgrade-running, database-command-timeout, database-connection-timeout, data-retrieval-services-enabled, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultcontentdb-password, defaultcontentdb-server, defaultcontentdb-user, delete-web-send-email, irmaddinsenabled, irmrmscertserver, irmrmsenabled, irmrmsusead, job-ceip-datacollection, job-config-refresh, job-database-statistics, job-dead-site-delete, job-usage-analysis, job-watson-trigger, large-file-chunk-size, token-timeout, workflow-cpu-throttle, workflow-eventdelivery-batchsize, workflow-eventdelivery-throttle, workflow-eventdelivery-timeout, workflow-timerjob-cpu-throttle, workitem-eventdelivery-batchsize, workitem-eventdelivery-throttle; SharePoint virtual server properties:, alerts-enabled, alerts-limited, alerts-maximum, change-log-expiration-enabled, change-log-retention-period, data-retrieval-services-enabled, data-retrieval-services-inherit, data-retrieval-services-oledb-providers, data-retrieval-services-response-size, data-retrieval-services-timeout, data-retrieval-services-update, data-source-controls-enabled, days-to-show-new-icon, dead-site-auto-delete, dead-site-notify-after, dead-site-num-notifications, defaultquotatemplate, defaulttimezone, delete-web-send-email, job-change-log-expiration, job-dead-site-delete, job-diskquota-warning, job-immediate-alerts, job-recycle-bin-cleanup, job-usage-analysis, job-workflow, job-workflow-autoclean, job-workflow-failover, max-file-post-size, peoplepicker-activedirectorysearchtimeout, peoplepicker-distributionlistsearchdomains, peoplepicker-nowindowsaccountsfornonwindowsauthenticationmode, peoplepicker-onlysearchwithinsitecollection, peoplepicker-searchadcustomquery, peoplepicker-searchadforests, presenceenabled, recycle-bin-cleanup-enabled, recycle-bin-enabled, recycle-bin-retention-period, second-stage-recycle-bin-quota, send-ad-email)
    161. stsadm -o setrecordsrepositoryschedule -schedule <recurrence string>
    162. stsadm -o setsearchandprocessschedule -schedule <recurrence string>
    163. stsadm -o setsharedwebserviceauthn -ntlm | -negotiate
    164. stsadm -o setsitedirectoryscanschedule -schedule <recurrence string> (Schedule parameter examples: "every 5 minutes between 0 and 59", "hourly between 0 and 59", "daily at 15:00:00", "weekly between Fri 22:00:00 and Sun 06:00:00", "monthly at 15 15:00:00", "yearly at Jan 1 15:00:00")
    165. stsadm -o setsitelock -url <url> -lock <none | noadditions | readonly | noaccess>
    166. stsadm -o setsspport -httpport <HTTP port number> -httpsport <HTTPS port number>
    167. stsadm -o setworkflowconfig -url <url> {-emailtonopermissionparticipants <enable|disable> | -externalparticipants <enable|disable> | -userdefinedworkflows <enable|disable>}
    168. stsadm -o siteowner -url <url> [-ownerlogin <DOMAIN\name>] [-secondarylogin <DOMAIN\name>]
    169. stsadm -o spsearch [-action <list | start | stop | attachcontentdatabase | detachcontentdatabase | fullcrawlstart | fullcrawlstop>] [-f (suppress prompts)] [-farmperformancelevel <Reduced | PartlyReduced | Maximum>] [-farmserviceaccount <DOMAIN\name> (service credentials)] [-farmservicepassword <password>] [-farmcontentaccessaccount <DOMAIN\name>] [-farmcontentaccesspassword <password>] [-indexlocation <new index location>] [-databaseserver <server\instance> (default: josebda-moss)] [-databasename <database name> (default: SharePoint_WSS_Search)] [-sqlauthlogin <SQL authenticated database user>] [-sqlauthpassword <password>] -action list -action stop [-f (suppress prompts)] -action start -farmserviceaccount <DOMAIN\name> (service credentials) [-farmservicepassword <password>] -action attachcontentdatabase [-databaseserver <server\instance> (default: josebda-moss)] -databasename <content database name> [-searchserver <search server name> (default: josebda-moss)] -action detachcontentdatabase [-databaseserver <server\instance> (default: josebda-moss)] -databasename <content database name> [-f (suppress prompts)] -action fullcrawlstart -action fullcrawlstop
    170. stsadm -o spsearchdiacriticsensitive [-setstatus <True|False>] [-noreset] [-force]
    171. stsadm -o sync {-ExcludeWebApps <web applications> | -SyncTiming <schedule(M/H/D:value)> | -SweepTiming <schedule(M/H/D:value)> | -ListOldDatabases <days> | -DeleteOldDatabases <days>}
    172. stsadm -o syncsolution -name <Solution name>] [-lcid <language>] [-alllcids]
    173. stsadm -o syncsolution -allsolutions
    174. stsadm -o unextendvs -url <url> [-deletecontent] [-deleteiissites]
    175. stsadm -o uninstallfeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-force]
    176. stsadm -o unquiescefarm
    177. stsadm -o unquiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>]
    178. stsadm -o unregistersecuritytrimmer -ssp <ssp name> -id <0 - 2147483647>
    179. stsadm -o unregisterwsswriter
    180. stsadm -o updateaccountpassword -userlogin <DOMAIN\name> -password <password> [-noadmin]
    181. stsadm -o updatealerttemplates -url <url> [-filename <filename>] [-lcid <language>
    182. stsadm -o updatefarmcredentials [-identitytype <configurableid/NetworkService>] [-userlogin <DOMAIN\name>] [-password <password>] [-local [-keyonly]]
    183. stsadm -o upgrade {-inplace | -sidebyside} [-url <url>] [-forceupgrade] [-quiet] [-farmuser <farm user>] [-farmpassword <farm user password>] [-reghost] [-sitelistpath <sites xml file>]
    184. stsadm -o upgradeformtemplate -filename <path to form template file> [-upgradetype <upgrade type>]
    185. stsadm -o upgradesolution -name <Solution name> -filename <upgrade filename> [-time <time to upgrade at>] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>]
    186. stsadm -o upgradetargetwebapplication -url <URL to upgrade> -relocationurl <new URL for non-upgraded content> -apidname <new app pool name> [-apidtype <configurableid/NetworkService>] [-apidlogin <DOMAIN\name>] [-apidpwd <app pool password>] [-exclusivelyusentlm]
    187. stsadm -o uploadformtemplate -filename <path to form template file>
    188. stsadm -o userrole -url <url> -userlogin <DOMAIN\name> -role <role name> [-add] [-delete]
    189. stsadm -o verifyformtemplate -filename <path to form template file>
    Tag: Sharepoint MOSS STSADM Bin Logs WSS STS Search Crawl "Content Deployment" Template Solution Schedule Migration Enum
     Activate Content Extent

    May 21

    New Rollups for WSS 952698 & MOSS 952704

    WSS Hotfix Final Release for Rollup KB 952698

    1. Moving links via sitemanager.aspx does not work.

    2. Content Deployment job is stuck in 'Preparing' status forever.

    3. Second full deployment un-ghosts pages on the target site which were ghosted.

    4. Synchronization problems when running multiple content deployment jobs.

    5. Incremental Content Deployment fails if a item has been renamed and new item with same name has been created.

    6. Incremental Content Deployment fails if a site is deleted and a new site is created with the same name.

    7. Variation page propagation performance improvement.

    8. Incremental Content Deployment fails if a file and a folder is deleted from a document library.

    9. DocLib Metadata is lost after upgrade from v2 to v3.

    10. Content Deployment Fails if compression is disabled.

    11. Incremental deployment fails if a publishing page was deleted and restored from the recycle bin.

    12. Incremental content deployment fails when feature with content type activated and deactivated without actually using the content type.

    13. The Service Account (System account) gets added to site collection when it is created through Self Site creation feature with require secondary contact enabled.

    14. Error Render failed when total column is more than 13 columns.

    15. Quick deploy job fails if more than one page is waiting to be quick deployed.

    16. Unable to download published version from the version history page for larger files.

    17. Content Deployment duplicates columns when using standard site definitions.

    18. Copy operations of Publishing Pages in Site Manager take around 20 minutes per item.



    MOSS Hotfix Final Release for Rollup KB 952704

    1. Search Keyword publishing dates are decremented by one after editing the keyword.

    2. HotFix for MOSS Post SP1 Roll-Up package: Get error when view or edit list item located on Navigation Bar after install Moss Post-SP1 Rollup package Q941274.

    3. Copy operations of Publishing Pages in Site Manager take around 20 minutes per item.

    Also: Plus whatever I’ve mentioned under KB 952698 list.

     

     Correct order to install the rollups -


    ================

    Order of installation:

    =================

    1.       WSS SP1

    2.       MOSS SP1

    3.       948945

    4.       941422

    5.       952698

    6.       952704

    PS: Regarding Previous Rollups please See this.


    Tags: moss sp1 wss sp1 sp2 sharepoint microsoft 948945 941422 952698 952704 service pack erp business application webpart spd "content deployment" quick deployment "doc lib" "document library " "sharepoint bugs"




    March 26

    SharePoint Capacity Planning Tool - Solution Accelerator

    SharePoint Capacity Planning Tool - Solution Accelerator

    Are you planning a SharePoint installation for a customer? Chances are, you have a lot of questions.

    • What is the necessary hardware investment?
    • What kind of topology is needed to meet organizational requirements for availability and performance?
    • How will additional users from a recent merger affect deployment?

    When planning a new SharePoint deployment, you will need a way to quickly characterize the general topology and minimum hardware requirements to support expected usage loads with adequate performance. You will need a way to explore plausible scenarios and get pointed in the right direction. The SharePoint Capacity Planning Tool gives you a quick way to draft topology and equipment sizing for your particular scenario and usage profile.

    This solution reduces “SharePoint sizing” estimation efforts from a matter of days to a matter of hours.
     

    Description of the Tool

    Imagine a tool that you could use to input a few key facts about users, user needs, business requirements, and organizational resources in order to:

    • Build a topology model based on this input
    • Run simulations that show the impact of this topology
    • Generate a summary report that will help you evaluate alternatives

    The SharePoint Capacity Planning Tool consists of System Center Capacity Planner 2007 (SCCP) models for:

    • Microsoft Office SharePoint Server 2007 (MOSS)
    • Windows SharePoint Services 3.0 (WSS)


    The tool can be used in pre-sales and feasibility studies of a deployment project to give you a rough estimate of hardware requirements. The tool can generate estimated performance metrics based on a simulation and provide useful Visio schematics of the proposed deployment to be included in documents and proposals.

     

    Overview 
    The SharePoint Capacity Planning Tool is a set of free models of Windows SharePoint Services 3.0 (WSS) and Microsoft Office SharePoint Server 2007 (MOSS). The two models use the analysis and simulation features of System Center Capacity Planner 2007 (SCCP) to help you explore suitable IT infrastructure options for your SharePoint deployment, based on the SharePoint usage requirements for your organization that you provide to the tool. It can give you a head start on planning your SharePoint topology by producing a first approximation of the topology your organization needs. Architects, systems integrators, and deployment engineers will find it to be a valuable starting point for further refinements of the topology.

    Feature Bullet Summary

    ·         Simple installation and setup

    ·         Built-in knowledge of Microsoft Office SharePoint Server 2007
    ·         Built-in knowledge of Windows SharePoint Services 3.0
    ·         Recommended topology in a Graphical User Interface
    ·         Export topology to Visio and server configuration to Excel
    ·         Create custom hardware

     

    Download Details.

    Customers can obtain the SharePoint Capacity Planning Tool on Microsoft Download. For a short introduction to the tool and its usage, please go to this TechNet overview page: http://go.microsoft.com/fwlink/?LinkID=93030

    This Solution Accelerator needs SCCP 2007 to be installed first.

    For details and download information for SCCP, please see Additional Resources.

    This Solution Accelerator is being included in Microsoft Services readiness material for SharePoint architecture and planning.

     
    Additional Resources

    SharePoint Capacity Planning Tool on Microsoft Download Center

    System Center Capacity Planner

    Solution Accelerators on TechNet  Tags: Sharepoint capacity planning

    March 06

    Moving MOSS 2007 Database from one server to another server.


    Moving SharePoint 2007 databases from one server to another server/instance

    The problem is that it is not that easy to just move the databases to a new database server and have everything work. In SharePoint 2003, it was relatively simple to move all the databases, but in 2007 there is a lot more involved with communication between the databases making it a more complicated scenario. Outlined below are the steps taken to move a SharePoint farm to a new database server.

    1. Perform a farm level backup of the current farm using the SharePoint backup utility in Central Administration. Make sure the backup gets saved to an accessible location either on this server or on the network.
    2. Run the SharePoint Products and Technologies Configuration Wizard to disconnect the server from the configuration database. If there is only one server in farm, then all you have to do is that server. If there are multiple servers in the farm, make sure the server running central administration is the last server disconnected from the farm. I don't believe this is a requirement, but I would recommend it anyway.
    3. Once all the servers have been removed from the farm. Run the SharePoint Products and Technologies Configuration Wizard on the server to host the central administration site first to create a new SharePoint farm. Once Server is configured, run the configuration wizard on the remaining servers adding them to the new SharePoint farm.
    4. Start both the Office SharePoint Services Search and the Windows SharePoint Services Search services
    5. Restore the backup made in step 1 using the SharePoint restore utility in Central Administration. You will have to supply the file path to the files that were backed up
      1. There are 4 steps to restoring from the backup. Step 1 is to locate the backup set that was ran in Step 1

      2. Step 2 is selecting a backup to restore from the location specified in the previous step

      3. Step 3 is selecting a component of the backup to restore... in this case you want to restore at the farm level

      4. Step 4 is to select the restore options. In this step you want to select new configuration for the type of restore and be sure to go through all the databases, web applicatons, and SSP information to specifiy the new database server name and database file locations for each item. Double check everything before hitting ok.

      5. Finally after all selections are made and the restore process is kicked off, you see a summary of the restore in progress.

    6. Once restore is complete the databases should be in their new location and the SSP should be backup and running. To finish the move, you must reconfigure the farm using central administration. Then kick off a full crawl to repopulate the content index.
    Other related resources:-

    How to move the databases that are used by SharePoint Portal Server 2003 to a computer that is running SQL Server

    http://support.microsoft.com/kb/894164/en-us

     

    How to move a WMSDE content database that resides on a Windows SharePoint Services 2.0 server to a Windows SharePoint Services 3.0 server

    http://support.microsoft.com/kb/925190/en-us

     

    How to move SharePoint Portal Server 2003 from MSDE to SQL Server

    http://support.microsoft.com/kb/837848/en-us

    Tags: "Moving SharePoint 2007 databases from one server to another server/instance" "Moving MOSS 2007 databases from one server to another server/instance" " Moving MOSS Database"


    Thanks,
    Saurabh


    February 28

    MOSS SP1 Rollup 941422 & 948945

    Post HotFix for MOSS SP1 Rollup

    List of issues Fixed by MOSS SP1 Rollup - Final Release KB 948945
     

    1. WSS12 - Incremental Content Deployment fails if workflow status fields were removed on the source site
    2. SRCH12 - Incremental Crawl does not complete - proc_MSS_ProcessLinks
    3. MOSS 2007 Content deployment import fails with Violation of PRIMARY KEY constraint WebParts_PK error
    4. WSS12 - Item versioning on a List with Lookup columns causes a SQL exception
    5. SRCH12 - The thumbnail displayed in the High Confidence results web part points to the internal URL and it does not honor the AAM setting
    6. WSS12 - Race Conditions in SPConfigurationDatabase initializaion leak FileSystemWatchers
    7. WSS12 - Unable to rename folders stored in a list
    8. WSS12 - Downloading a document from a IRM protected document library will cause server 100% CPU
    9. WSS12 - Clicking a Document link which points to a URL containing Chinese will cause "404 not found" error
    10. WSS12 - Task updates sends phantom AssignedTo email notifications with no update to field
    11. WSS12 - The extreme slowness (15secs) we experience in the stored proc responsible for getting the ACL for an item (proc_SecGetListItemSecurity) when the count of items in a List exceeds 500,000.
    12. WSS12 - Exporting from a Recovery farm and importing on Production farm fails for a site collection if limits are set for Major and Minor versions
    13. SRCH12 - "Did you mean" functionality checks only last word in phrase
    14. WSS12 - Gantt Chart Today Shading time should be of Local System instead of UTC time
    15. SRCH12 - Best Bets do not get returned when using advanced search -> All these words

    List of issues Fixed by MOSS SP1 Rollup - Final Release KB 941422

    1. MOSS 2007: Missing timer jobs when you backup and restore.
    2. WSS 3.0: Site Templates does not contain standard WebParts
    3. WSS: Posting a blog entry returns error 'Word cannot register your account..:'
    4. CDCR: New Zealand timezone changes - WSS/SPS 12
    5. RFH: Error Exporting to Spreadsheet after changing date field requirement with Excel2003
    6. SPSv2->MOSS:WSS: Error message on upgrading Discussion boards: "Violation of UNIQUE KEY constraint 'AllUserData_Url'"
    7. SPIncludeDescendents property does not function properly when SPExportObjectType is set as SPFolder
    8. SRCH12 - Search Results HTML rendering error when folder name has a trailing period
    9. WSS: RSS Feed update is delayed in Outlook and IE client
    10. SRCH12 - ACL changes did not get picked up via incremental crawl for FileShare
    11. STSv2 --> WSS: SiteCount increments each time 'Refresh site list' is clicked during Gradual Upgrade
    12. SRCH12 - BDC Content Source Not Returning Search For Single Words
    13. WSS 3.0 - Welcome email retains OLD site name
    14. SRCH12 - Cannot search for anything beyond the second slide of a powerpoint (ppt) presentation
    15. WSS: Limited permissions prevent restore from recycle bin into source folder
    16. WSSv3: RHF: Calendar View of Calendar web part causes the page to fail to be rendered for a user without the reader permission to this list
    17. WSSv3: RFH: Order changed on custom list column after upgrade
    18. SRCH12 - Excel file are not filtered if the name definition for string are existing.
    19. WSS: 2007 Document Library issue with folder named - Forms
    20. WSSv3: RFH: SpWriter fails in OnIdentify if multiple SSPs get enabled on a MOSS farm
    21. SRCH12 - While crawling FBA content, some cookies in the response can be skipped
    22. WSSV3:Track Passport users by their PUID – need complete fix (Office Live)
    23. WSS V3: Perf Fix for stored proc proc_SecListScopeGroups (Office Live)
    24. WSSv3 RFH: XSLT grouping in data views doesn't work beyond 3 levels
    25. Custom view settings of list view web part in web part pages are lost during content deployment
    26. WSSv3: User SIDs shortened likely when migrating user accounts via V3 stsadm -migrateuser command
    27. WSS12 - Break item level inheritance takes too long, follow up of QFE 17975
    28. WSS PRIME: Incremental Content Deployment fails if a list is deleted and a new list is created with the same name.
    29. SRCH12 - OSearch leaks memory when crawling a BDC and SharePoint content source
    30. WSS- Customer needs hotfix for OfficeQFE:19123 before SP1
    31. WSS - Upgrade action Detecting Security Setting Corruptions does not handle host header mode well (Office Live)
    32. Could not start the Windows SharePoint Services Administration Service on local computer after 6036 PU

    To obtain the above rollups for MOSS SP1, you may please contact