ABAP - Data Dictionary Introduction

Data dictionary provide:
1. Table definition
2. Type definition

Data dictionary can be accessed by transaction code SE11. (SAP Menu->Tools->ABAP Workbench->Development->Data Dictionary).

Table definition.
Display table definition.Go to Transaction Code SE11, enter table name (example: SFLIGHT), click Display.

You can assign the data type, length and short text in different ways:
1. You directly assign the field a data type, field length (and if necessary decimal places) and short text in the table definition.
2. You can assign the field a data element. The data type, field length (and decimal places) are determined from the domain of the data element. The short description of the data element is assigned to the field as a short text. In above case, all fields refer to data element (Field CARRID refer to date element S_CARR_ID). We will explain about data element in Type Definition below.To toggle beetween data element / direct type method click button "Data Element/Direct type".
To display table content, click Utilities -> Table Contents -> Display, then click Execute (F8).
Type DefinitionWe can define type as reusable object. It means that when we create new table, we can create field refer to data element. These type attributes can either be defined directly in the data element or copied from a domain. Data element is an object where we put short text for field, and domain is an object where we store information like data type (CHAR, NUMC) and its length. We can see relation beetween table field, data element and domain in figure below.

Benefit of using this hierarchy is when you change domain, for example change field length, it will change all field length for all table using this domain.
To open a data element, go to TCode SE11, select data type, and enter data element name (for example S_CARR_ID). You will see in this screen that data element S_CARR_ID refer to domain S_CARR_ID ( in this case, data element and domain have a same name), and also display field label tab, it contain short text that appear in short text of table field.
To open a domain, go to TCode SE11, select domain, and enter domain name (for example S_CARR_ID), you will see that this domain have CHAR (character) data type and field length 3.

VSTA Integration with InfoPath

We don't need the VSTA SDK to use VSTA in InfoPath 2007. We need some prerequisites and  make a specific selection in setup:

Microsoft .NET Framework 2.0 (or later) and Microsoft Core XML Services (MSXML) 6.0 must be installed first.

The VSTA development environment is not installed by default when you choose Typical to install InfoPath. To install VSTA, you must either choose Customize when first installing, or use Add or Remove Programs to update your Office or InfoPath installation to include VSTA. The option to install VSTA is available by expanding Microsoft Office InfoPath, .NET Programmability Support, and .NET Programmability Support for .NET Framework version 2.0. The easiest way to do this, is to expand .NET Programmability Support, and then choose Run All From My Computer.

Then, you need to configure your InfoPath form template to use managed code. Open the form template in Design view, click Form Options on the Tools menu, and then click Programming in the Category list. Under Programming, set the Form template code language to either Visual Basic or C#. After doing that, you should have Microsoft Visual Studio Tools for Applications under Tools > Programming.

Testing:

On the InfoPath form 2007 click Button --> Edit Form Code and then start writing the code...
Ex:
//InfoPath SQL Database integration - accessing data from sql through Stored procedures in InfoPath
var serviceid = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:titleauthor/@serviceid").text;

//Set the Command for the Query Adapter of the Data Source. Incorporate the
//parameter values that you want to use.
XDocument.QueryAdapter.Command = 'execute "dbo".""storedprocname" ' + serviceidValue;

//Query the Data Source.
XDocument.Query();

InfoPath - Inserting line breaks into text using Rules

Create a new XML file 'linebreak.xml' and save it.

<?xml version="1.0" encoding="UTF-8"?>
<characters
    cr="&#xD;"
    lf="&#xA;"
    crlf="&#xD;&#xA;"
/>

Then in InfoPath go to Tools | Data Connections and click Add. Select Receive data, then XML Document. Browse to characters.xml then complete the wizard. When it asks “The selected file is not part of the form...add this file...?” click Yes. At this point we’ve just added a resource file to the template that gets loaded into a declaratively-accessible DOM - no code required.

Testing it:

Add a Button control, open up the properties and click Rules. Add a Rule, and add an Action of the type “Set a field’s value”. For the field pick the text box’s field (e.g. field1). For the new value, use the formula builder and build the following expression:

concat(field1, @crlf, "Hello, World!")

Result would look like:

field1Value
Hello, World!

 

Time Zone Webpart (CEWP)

In the CEWP add this code and in any document library add timezone.js and reference it properly

<style type="text/css">
 th {filter: progid:DXImageTransform.Microsoft.gradient( startColorstr='#fcfff4', endColorstr='#b3bead',undefined ); /* ie */ }
</style>
<table align="center" border="1" bordercolor="black"cellpadding="0" cellspacing="0" width="100%">
<tr>
 <th align="center" valign="middle">EST</th>
 <th align="center" valign="middle">CST</th>
 <th align="center" valign="middle">MST</th>
 <th align="center" valign="middle">PST</th>
</tr>
<tr>
 <td align="center" valign="middle"><span id="tEST">&nbsp;</span></td>
 <td align="center" valign="middle"><span id="tCST">&nbsp;</span></td>
 <td align="center" valign="middle"><span id="tMST">&nbsp;</span></td>
 <td align="center" valign="middle"><span id="tPST">&nbsp;</span></td>
</tr>
</table>

<script type="text/javascript" src="js\TimeZone.js"></script>





TimeZone.js:



function timeSource(tz){
   x=new Date(timeNow().getUTCFullYear(),timeNow().getUTCMonth(),timeNow().getUTCDate(),timeNow().getUTCHours(),timeNow().getUTCMinutes(),timeNow().getUTCSeconds());
   switch(tz)
   {
  case 0: /*PST*/
   x.setTime(x.getTime()+daylightSaving()-28800000);
   break ;
  case 1: /*MST*/
   x.setTime(x.getTime()+daylightSaving()-25200000);
   break ;
  case 2: /*CST*/
   x.setTime(x.getTime()+daylightSaving()-21600000);
   break;
  case 3: /*EST*/
   x.setTime(x.getTime()+daylightSaving()-18000000);
   break;
   }
  
   return x;
}
function timeNow(){
   return new Date();
}
function daylightSaving(){
   return ((timeNow().getTime()>findDay(0,3,1,1).getTime())&&(timeNow().getTime()<findDay(0,9,1,-1).getTime()))?3600000:0;
}
function findDay(d,m,h,p){
   var week=(p<0)?7*(p+1):7*(p-1),nm=(p<0)?m+1:m,x=new Date(timeNow().getUTCFullYear(),nm,1,h,0,0),dOff=0;
   if(p<0){
      x.setTime(x.getTime()-86400000);
   }
   if(x.getDay()!=d){
      dOff=(x.getDay()<d)?(d-x.getDay()):0-(x.getDay()-d);
      if(p<0&&dOff>0){
         week-=7;
      }
      if(p>0&&dOff<0){
         week+=7;
      }
      x.setTime(x.getTime()+((dOff+week)*86400000));
   }
   return x;
}
function leadingZero(x){
   return (x>9)?x:'0'+x;
}
function twelveHour(x){
   if(x==0){
      x=12;
   }
   return (x>12)?x-=12:x;
}
function dateEnding(x){
   if(x==1||x==21||x==31){
      return 'st';
   }
   if(x==2||x==22){
      return 'nd';
   }
   if(x==3||x==23){
      return 'rd';
   }
   return 'th';
}
function displayTime(){
   document.getElementById('tPST').innerHTML=eval(outputTimePST);
   document.getElementById('tMST').innerHTML=eval(outputTimeMST);
   document.getElementById('tCST').innerHTML=eval(outputTimeCST);
   document.getElementById('tEST').innerHTML=eval(outputTimeEST);
   setTimeout('displayTime()',1000);
}
function amPMsymbol(x){
   return (x>11)?'pm':'am';
}
function fixYear4(x){
   return (x<500)?x+1900:x;
}
var dayNames=new Array('Sunday','Monday','Tuesday','Wednesday','Thursday','Friday','Saturday');
var monthNames=new Array('January','February','March','April','May','June','July','August','September','October','November','December');
var outputTimePST="dayNames[timeSource(0).getDay()]+' '+timeSource(0).getDate()+dateEnding(timeSource().getDate())+' '+monthNames[timeSource(0).getMonth()]+' '+fixYear4(timeSource(0).getYear())+' '+':'+':'+' '+twelveHour(timeSource(0).getHours())+':'+leadingZero(timeSource(0).getMinutes())+':'+leadingZero(timeSource(0).getSeconds())+amPMsymbol(timeSource(0).getHours())";
var outputTimeMST="dayNames[timeSource(1).getDay()]+' '+timeSource(1).getDate()+dateEnding(timeSource().getDate())+' '+monthNames[timeSource(1).getMonth()]+' '+fixYear4(timeSource(1).getYear())+' '+':'+':'+' '+twelveHour(timeSource(1).getHours())+':'+leadingZero(timeSource(1).getMinutes())+':'+leadingZero(timeSource(1).getSeconds())+amPMsymbol(timeSource(1).getHours())";
var outputTimeCST="dayNames[timeSource(2).getDay()]+' '+timeSource(2).getDate()+dateEnding(timeSource().getDate())+' '+monthNames[timeSource(2).getMonth()]+' '+fixYear4(timeSource(2).getYear())+' '+':'+':'+' '+twelveHour(timeSource(2).getHours())+':'+leadingZero(timeSource(2).getMinutes())+':'+leadingZero(timeSource(2).getSeconds())+amPMsymbol(timeSource(2).getHours())";
var outputTimeEST="dayNames[timeSource(3).getDay()]+' '+timeSource(3).getDate()+dateEnding(timeSource().getDate())+' '+monthNames[timeSource(3).getMonth()]+' '+fixYear4(timeSource(3).getYear())+' '+':'+':'+' '+twelveHour(timeSource(3).getHours())+':'+leadingZero(timeSource(3).getMinutes())+':'+leadingZero(timeSource(3).getSeconds())+amPMsymbol(timeSource(3).getHours())";
if(!document.all){ window.onload=displayTime; }else{ displayTime(); }




Reference:
// Clock Script Generated By Maxx Blade's Clock v2.0d
// http://www.maxxblade.co.uk/clock

Rich Text Column in Document Library

WSS – Rich Text column in Document Library

Being not able to add a rich text column to a document library, is frustrating as I wanted to use the column to hold rich text. It is possible to use a rich text column in a doc library but it must be done using a content type, Here are some instructions below on to get a document library setup with a rich text column:

1. Configure ‘Advanced Settings’ for the document library and enable the management of content types.
2. Create a new Site Column as multiline rich text.
3. Create a new Content Type and add the column created in step 2.
4. Add the Content Type to the document library using the ‘Add from existing site content types’ link.
5. Save the document library as a template and delete the document library.
6. Create the document library again using the template from step 5.
7. Success! You should now be able to use a rich text column within a document library.

Thanks:  http://sharepointcoding.wordpress.com/2009/05/28/wss-rich-text-column-in-document-library/

List - Update Columns behind the screen based on other columns

<script language="javascript" type="text/javascript">
_spBodyOnLoadFunctionNames.push("populateFieldvalues");

    var populate = getField('select','Current Status');
    populate.onchange = populateFieldvalues;

    function populateFieldvalues() {
        var control = getField('select','Current Status'); //Based on the Value of this 'Current Status', Status &Description will be changed. Ex: If yellow is selected for 1 column, other column named Status, its URL and Desc would be changed accordingly.
        var Statusurl = getField('input', 'Status');
        var Statusdesc = getField('input', 'Description');

        if (control.options[0].selected) {
            Statusurl.value = "http://YourServer/sites/SC1/SubSite1/ImageLibrary/white.gif";
            Statusdesc.value = "White";
            }
           
        else if (control.options[1].selected) {
            Statusurl.value = "http://YourServer/sites/SC1/SubSite1/ImageLibrary/green.gif";
            Statusdesc.value = "Green";
            }

        else if (control.options[2].selected) {
            Statusurl.value = "http://YourServer/sites/SC1/SubSite1/ImageLibrary/yellow.gif";
            Statusdesc.value = "Yellow";
            }
           
        else if (control.options[3].selected) {
            Statusurl.value = "http://YourServer/sites/SC1/SubSite1/ImageLibrary/red.gif";
            Statusdesc.value = "Red";
            }

        }

    function getField(fieldType,fieldTitle) {
           var docTags = document.getElementsByTagName(fieldType);
        for (var i=1; i < docTags.length; i++) {
            if (docTags[i].title == fieldTitle) {
                return docTags[i];
            }
           }
    }
   
</script>

Creating and Customizing Document Information Panel with Infopath 2007

Document Information Panel

Announcements ListView WebPart - Modifying View

Using Sharepoint Designer, change the existing listView to XSL DataView and then change the following to modify the view:

<xsl:template name="dvt_1.rowview">
        <p class="ms-vb">
             <a href="http://YourServer/sites/Dev1/Lists/NameOfList/DispForm.aspx?ID={@ID}"><xsl:value-of select="@Title" /></a>
            <br />By
            <xsl:value-of select="@Author" disable-output-escaping="yes" /><br />
            <xsl:value-of select="@Body" disable-output-escaping="yes" /></p></xsl:template>

Bulk Update List Items using JQuery WebService

Querying and Updating the List

(1)Add a CEWP on any default.aspx page [Not on any of the List view pages]
(2)Copy paste the code and change URLs for List and Site along with Column names that you want to Update with
(3) 2 functions btnPublishAll() - Gets each List items ID's and Title  and fxnPublishList() - Updates each List item's PublishColumn to Published.
(4)Add your list(YourListName) webpart on the same page, so that Button to bulk publish all items for the List and List would be on the same page.


<script type="text/javascript">

$(function($){
        $("#btnPublishAll").click(function(){
           var soapEnv =
            "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
                <soapenv:Body> \
                     <GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
                        <listName>YourListName</listName> \
                        <viewFields> \
                            <ViewFields> \
                               <FieldRef Name='ID' /> \
                               <FieldRef Name='Publish' /> \
                           </ViewFields> \
                        </viewFields> \
                    </GetListItems> \
                </soapenv:Body> \
            </soapenv:Envelope>";

        $.ajax({
            url: "http://YourServer/sites/Dev1/myDev1/_vti_bin/lists.asmx",
            type: "POST",
            dataType: "xml",
            data: soapEnv,
            complete: processResult,
            contentType: "text/xml; charset=\"utf-8\""
        }); // end $.ajax()

                function processResult(xData, status) {
                     $(xData.responseXML).find("z\\:row").each(function() {
                     //Here you get the ID's of each Item in the List and we can call Update function using these ID's
                      var liHtml = "<li>" + $(this).attr("ows_Title") + "</li>"; //To Display each List items Title in a row
                      //$("#TestUL").append(liHtml);
                       fxnPublishList( $(this).attr("ows_ID"), "Published" ) ;
                        window.location="YourPage"; //To Refresh the page after the Update.
                                   
                  });
                } // end processResult
                                               
                                               
   }); // end click
  
 
  
}); // end ready

function fxnPublishList(ItemID,ItemNewValue)
{
    var soapEnv =
        "<?xml version='1.0' encoding='utf-8'?> \
            <soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \
                <soapenv:Body> \
                     <UpdateListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'> \
                        <listName>YourListName</listName> \
                        <viewName>AllItems</viewName> \
                        <updates><Batch OnError='Continue' PreCalc='TRUE'> \
                               <Method ID='1' Cmd='Update'> \
                                  <Field Name='Publish'>" + ItemNewValue + "</Field> \
                                  <Field Name='ID'>" + ItemID + "</Field> \
                               </Method> \
                        </Batch></updates> \
                    </UpdateListItems> \
                </soapenv:Body> \
            </soapenv:Envelope>";
   
    $.ajax({
        url: "http://YourServer/sites/Dev1/myDev1/_vti_bin/lists.asmx",
        beforeSend: function(xhr){ xhr.setRequestHeader("SOAPAction","http://schemas.microsoft.com/sharepoint/soap/UpdateListItems");},
        type: "POST",
        dataType: "xml",
        data: soapEnv,
        contentType: "text/xml; charset=\"utf-8\""
    }); // end $.ajax()
}


</script>
<p/><p/>
<input type="button" id="btnPublishAll" value="Publish All" />


Reference:  Link to Jan Tielens Blog for querying list items.

Build URL for webservices Ex: Lists.asmx

 var hrefParts = window.location.href.split('/');
            var wsURL = "";
            for (i = 0; i < (hrefParts.length - 2); i++) {
                if (i > 0)
                    wsURL += "/";
                wsURL += hrefParts[i];
            }
            wsURL += "/_vti_bin/lists.asmx";

Remove *Title Column in a Sharepoint List

Using jQuery to fix the removal of the Title column of a list

 

SharePoint List items all have a Title column (although it’s display name might be changed to something else). This Title column is a string, which is unfortunate as sometimes you really don’t need a string column on a list; this was the need I faced.
You can make a Title column not required:

Also, if you go to the ‘Advanced Settings’ page of your list and ‘Allow management of Content Types’ you can then go into your content types and Hide the Title column. This is okay – but the Title column is still there – it’s just being displayed with “(no title)”…

That’s not such a problem for views on a list – you can simply choose to not show the Title column. But unfortunately, some other pages (such as EditForm.aspx and DispForm.aspx) use the Title column in their title and navigation:

“(no title)” sucks a bit, especially as we probably do have something better to use as a title. I decided to use jQuery to replace the “(no title)”s in the Edit and Display forms:

Or, as text:
<script language="javascript" type="text/javascript">
$(document).ready(function() {
var user = $("span[class='ms-entity-resolved'] > span[id='content']");
var userText = user.text();
document.title = "Users - " + userText;
var pageTitle = $("h2[class='ms-pagetitle']");
var pageTitleHtml = pageTitle.html();
pageTitle.html(pageTitleHtml.replace("(no title)",userText));
var pageLink = $("td[class='ms-titlearea']");
var pageLinkHtml = pageLink.html();
pageLink.html(pageLinkHtml.replace("(no title)",userText));
});
</script>
Here I’m getting the new title from my user field – but you might want to use another field. Whatever, the same principle of using jQuery to get the value would work.
Then I update the Browser’s title bar with the new title.
Next, I select the page title and replace “(no title)” with my new title, before writing the html back, and finally I repeat this with the “(no title)” link in the breadcrumb. The end result is:

Nice. I repeated this for my Dispform.aspx too, though not the new Item form – it doesn’t display the title at all (as a new item doesn’t have one yet!) I also added an edit button to my list so that users can still edit these items:

(And yes, there are other ways of dealing with this – building  proper custom edit and display forms, for example – but this is quite low effort)

Reference:  http://www.novolocus.com/2009/06/02/using-jquery-to-remove-the-title-of-a-list/

Show/Hide free form text field on dropdown choice : Specify your own value

<script type="text/javascript" src="http://YourServer/development/jQuery/jquery-1.4.2.min.js"></script>
<script type="text/javascript">

$(document).ready(function() {

 //will  hide as the default selected column value is other than "Other" .
   var TitleSpan = $("span[Title='ColumnInternalName: Specify your own value:']").closest("tr").hide();
   var TitleInput = $("input[Title='ColumnInternalName : Specify your own value:']").closest("tr").hide();

//on dropdown choice change, we can show or hide the "specify your own value"
   $("select[title$=Column Name: Choice Drop Down']").change(function()
   {
     var selectedItem = $("#ctl00_m_g_XXXXXX_ctl00_DropDownChoice :selected").text();
     if(selectedItem == "Other")
      {
          var TitleSpan = $("span[Title='Column Name: Specify your own value:']").closest("tr").show();
          var TitleInput = $("input[Title='Column Name : Specify your own value:']").closest("tr").show();
      }
      else
      {
          var TitleSpan = $("span[Title=Column Name: Specify your own value:']").closest("tr").hide();
          var TitleInput = $("input[Title=Column Name : Specify your own value:']").closest("tr").hide();
      }
    });
 
 
});

</script>

SharePoint 2010 Certification and SharePoint 2007 Certification

I’m a big proponent of the Microsoft Certification program and think that anyone in the IT industry working with Microsoft technologies should have a certification for their field.Do I think a certification means that you know what you are doing?  Nope… I’ve met people that have certifications, and didn’t know diddly-squat when it came to ‘real-world’ work.  To the contrary, I’ve also met people that do not have certifications, but know a specific technology inside and out.
Still, I think it’s beneficial to anyone’s career and something that I’m an advocate of.  Why is it beneficial though? The Microsoft Learning website puts it best:

Build your expertise and advance your career. By earning a Microsoft Certification, you gain advanced, market-relevant skills that employers recognize and respect as well as opportunities to connect with a global community of other certified professionals. Additionally, certification provides you with access to exclusive Microsoft resources and benefits, such as the MCP member Web site, career-building tools, and training. Explore the benefits of certification—and start your journey to attaining your ideal career.

To date, I’ve been pretty disappointed in the lack of certifications available for SharePoint 2007.  Let’s look at what we currently have.

Existing SharePoint 2007 Certifications

MCTS – Microsoft Certified Technology Specialist

IT Pro
Exam 70-630: TS: Office SharePoint Server 2007, Configuring
Exam 70-631: TS: Configuring Windows SharePoint Services 3.0
Dev Exam 70-541: TS: Microsoft Windows SharePoint Services 3.0 - Application Development
Exam 70-542 : TS: Microsoft Office SharePoint Server 2007, Application Development

So the inherent problem in my opinion now becomes apparent… MCTS is the lowest level of Microsoft Certification, and the next available certification is the Master program.
MCM – Microsoft Certified Master

IT Pro / Dev
Microsoft Certified Master: Microsoft Office SharePoint Server 2007

The Master program is an advanced certification, and costs a good bit of money as well. It’s worth it for sure, I will not argue against this.  It’s a true practical test of your ability, and comes with 3 weeks of classroom courses led by some of the industry’s best.
But for a certification ‘path’, it has not existed for SharePoint.  There is the lower certification and the advanced certification – nothing in the middle.

Future SharePoint 2010 Certifications
(Disclaimer: this information is not confirmed or posted anywhere that I have seen.  Its based upon printed marketing material, and the 2010 certification release of other server platforms.)

With the release of SharePoint 2010 this year, there will also be a release of new certifications.  The best part however, is that there will be the release of additional certifications that will fill the gap of that middle-ground.
MCTS – Microsoft Certified Technology Specialist

SharePoint Server 2010
Exam 70-667: TS: Microsoft SharePoint 2010, Configuring
Developer, SharePoint Server 2010 Exam 70-573: TS: Microsoft SharePoint 2010, Application Development

MCITP – Microsoft Certified IT Professional

SharePoint Server 2010
Exam 70-668: PRO: SharePoint 2010, Administrator

MCPD– Microsoft Certified Professional Developer

Developer, SharePoint Server 2010
Exam 70-576: PRO: Designing and Developing Microsoft SharePoint 2010 Applications

MCM – Microsoft Certified Master

IT Pro / Dev
Microsoft Certified Master: SharePoint Server 2010

Although I’m not graphically showing a road map here, as you may be able to interpret these are in order of a career path, so MCTS would come before MCITP / MCPD and those would come before MCM.  There are also plans for a MCA (Microsoft Certified Architect) that have not been released.  Essentially that’s the cream of the crop.
Now that I think about it, the Microsoft Certification path follows almost a Higher Education academic degree system, and probably not by mistake.

MCTS = Associate’s Degree
MCITP/MCPD = Bachelor’s Degree
MCM = Master’s Degree
MCA = Doctoral Degree

I’m pretty pumped about the new certs coming out.  If you don’t have any certifications associated with your name, it will be a great year to get started.  :)

Thanks to Dan Lewis for his post.

STSADM full commands for MOSS 2007 SP1

The following command are the STSADM tool commands for MOSS 2007 SP1. The STSADM is a great utility that you can REALLY control anything in your MOSS server. The underlined commands can ONLY be used with SP1:

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 <email address> -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 <email address> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <email address>] [-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 <email address> [-ownerlogin <DOMAIN\name>] [-ownername <display name>] [-secondaryemail <email address>] [-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 <email address> -replytoaddress <email address> -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 <email address> [-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 getsiteuseraccountdirectorypath -url <url>
102. stsadm -o geturlzone -url <protocol://incoming.url.domain>
103. stsadm -o grantiis7permission
104. 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]
105. stsadm -o installfeature {-filename <relative path to Feature.xml from system feature directory> | -name <feature folder>} [-force]
106. stsadm -o listlogginglevels [-showhidden]
107. stsadm -o listregisteredsecuritytrimmers -ssp <ssp name>
108. stsadm -o localupgradestatus
109. 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>]
110. stsadm -o mergecontentdbs -url <url> -sourcedatabasename <source database name> -destinationdatabasename <destination datbabase name> [-operation <1-3> 1 - Analyze (default) 2 - Full Database Merge 3 - Read from file] [-filename <file generated from stsadm -o enumsites>]
111. stsadm -o migrateuser -oldlogin <DOMAIN\name> -newlogin <DOMAIN\name> [-ignoresidhistory]
112. 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>] [-cleansearchdatabase <true|false>] [-ssp <ssp name>] required parameter for 'cleansearchdatabase'
113. stsadm -o osearchdiacriticsensitive -ssp <ssp name> [-setstatus <True|False>] [-noreset] [-force]
114. stsadm -o preparetomove {-ContentDB <DatabaseServer:DatabaseName> | -Site <URL>} [-OldContentDB <uniqueidentifier>] [-undo]
115. stsadm -o profilechangelog -title <SSP Name> -daysofhistory <number of days> -generateanniversaries
116. stsadm -o profiledeletehandler -type <Full Assembly Path>
117. stsadm -o provisionservice -action <start/stop> -servicetype <servicetype (namespace or assembly qualified name if not SharePoint service)> [-servicename <servicename>]
118. stsadm -o quiescefarm -maxduration <duration in minutes>
119. stsadm -o quiescefarmstatus
120. stsadm -o quiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>] -maxduration <time in minutes>
121. stsadm -o reconvertallformtemplates
122. stsadm -o refreshdms -url <url>
123. stsadm -o refreshsitedms -url <url>
124. 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 '~'>]
125. stsadm -o registerwsswriter
126. stsadm -o removedataconnectionfile -filename <filename to remove>
127. stsadm -o removedrservice -servicename <data retrieval service name> -setting <data retrieval services setting>
128. stsadm -o remove-ecsfiletrustedlocation -Ssp <SSP name> -Location <URL|UNC> -LocationType SharePoint|Unc|Http
129. stsadm -o remove-ecssafedataprovider -Ssp <SSP name> -ID <data provider id> -Type Oledb|Odbc|OdbcDsn
130. stsadm -o remove-ecstrusteddataconnectionlibrary -Ssp <SSP name> -Location <URL>
131. stsadm -o remove-ecsuserdefinedfunction -Ssp <SSP name> -Assembly <strong name|file path> -AssemblyLocation GAC|File
132. stsadm -o removeexemptuseragent -name <user-agent to receive InfoPath files instead of a Web page>
133. stsadm -o removeformtemplate [-formid <form template ID>] [-filename <path to form template file>]
134. stsadm -o removesolutiondeploymentlock [-server <server> [-allservers]
135. stsadm -o renameserver -oldservername <oldServerName> -newservername <newServerName>
136. stsadm -o renamesite -oldurl <oldUrl> -newurl <newUrl> 
137. stsadm -o renameweb -url <url> -newname <new subsite name>
138. stsadm -o restore -url <url> -filename <filename> [-hostheaderwebapplicationurl <web application url>] [-overwrite]
139. 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]
140. 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>]
141. stsadm -o retractsolution -name <Solution name> [-url <virtual server url>] [-allcontenturls] [-time <time to remove at>] [-immediate] [-local] [-lcid <language>]
142. stsadm -o retractwppack -name <Web Part Package name> [-url <virtual server url>] [-time <time to retract at>] [-immediate] [-local] [-lcid <language>]
143. stsadm -o runcmsmigrationprofile -profilename <profile name> [-skipanalyzer ] [-onlyanalyzer ] [-startover ] [-migratesincetime <DateTime string>] [-migrationfolder <path>] [-exportonly ] [-importonly ] [-htmldiff <path>]
144. stsadm -o runcontentdeploymentjob -jobname <name> [-wait yes|no] [-deploysincetime <datetime>] (<datetime> as "MM/DD/YY HH:MM:SS")
145. stsadm -o scanforfeatures [-solutionid <Id of Solution>] [-displayonly]
146. stsadm -o setadminport -port <port> [-ssl] [-admapcreatenew] [-admapidname <app pool name>]
147. stsadm -o setapppassword -password <password>
148. stsadm -o setbulkworkflowtaskprocessingschedule -schedule <recurrence string>
149. 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>]
150. 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")
151. stsadm -o setdataconnectionfileproperty -filename <filename of the data connection file> -pn <property name> -pv <property value>
152. stsadm -o setdefaultssp -title <SSP name>
153. stsadm -o set-ecsexternaldata -Ssp <SSP name> [-ConnectionLifetime <time in seconds>] [-UnattendedServiceAccountName <account name>] [-UnattendedServiceAccountPassword <account password>]
154. stsadm -o set-ecsloadbalancing -Ssp <SSP name> [-Scheme WorkbookUrl|RoundRobin|Local] [-RetryInterval <time in seconds>]
155. stsadm -o set-ecsmemoryutilization -Ssp <SSP name> [-MaxPrivateBytes <memory in MBytes>] [-MemoryCacheThreshold <percentage>] [-MaxUnusedObjectAge <time in minutes>]
156. stsadm -o set-ecssecurity -Ssp <SSP name> [-FileAccessMethod UseImpersonation|UseFileAccessAccount] [-AccessModel Delegation|TrustedSubsystem] [-RequireEncryptedUserConnection False|True] [-AllowCrossDomainAccess True|False]
157. stsadm -o set-ecssessionmanagement -Ssp <SSP name> [-MaxSessionsPerUser <number of sessions>]
158. stsadm -o set-ecsworkbookcache -Ssp <SSP name> [-Location <local or UNC path>] [-MaxCacheSize <storage in Mbytes>] [-EnableCachingOfUnusedFiles True|False]
159. stsadm -o setformsserviceproperty -pn <option name> -pv <option value>
160. stsadm -o setformtemplateproperty [-formid <form template ID>] [-filename <path to form template file>] -pn <property name> -pv <property value>
161. stsadm -o setholdschedule -schedule <recurrence string>
162. 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>] }
163. stsadm -o setpolicyschedule -schedule <recurrence string>
164. 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)
165. stsadm -o setrecordsrepositoryschedule -schedule <recurrence string>
166. stsadm -o setsearchandprocessschedule -schedule <recurrence string>
167. stsadm -o setsharedwebserviceauthn -ntlm | -negotiate
168. 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")
169. stsadm -o setsitelock -url <url> -lock <none | noadditions | readonly | noaccess>
170. stsadm -o setsiteuseraccountdirectorypath -url <url> [-path <path>]
171. stsadm -o setsspport -httpport <HTTP port number> -httpsport <HTTPS port number>
172. stsadm -o setworkflowconfig -url <url> {-emailtonopermissionparticipants <enable|disable> | -externalparticipants <enable|disable> | -userdefinedworkflows <enable|disable>}
173. stsadm -o siteowner -url <url> [-ownerlogin <DOMAIN\name>] [-secondarylogin <DOMAIN\name>]
174. 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
175. stsadm -o spsearchdiacriticsensitive [-setstatus <True|False>] [-noreset] [-force]
176. stsadm -o sync {-ExcludeWebApps <web applications> | -SyncTiming <schedule(M/H/D:value)> | -SweepTiming <schedule(M/H/D:value)> | -ListOldDatabases <days> | -DeleteOldDatabases <days>}
177. stsadm -o syncsolution -name <Solution name>] [-lcid <language>] [-alllcids]
178. stsadm -o syncsolution -allsolutions
179. stsadm -o unextendvs -url <url> [-deletecontent] [-deleteiissites]
180. stsadm -o uninstallfeature {-filename <relative path to Feature.xml> | -name <feature folder> | -id <feature Id>} [-force]
181. stsadm -o unquiescefarm
182. stsadm -o unquiesceformtemplate [-formid <form template ID>] [-filename <path to form template file>]
183. stsadm -o unregistersecuritytrimmer -ssp <ssp name> -id <0 - 2147483647>
184. stsadm -o unregisterwsswriter
185. stsadm -o updateaccountpassword -userlogin <DOMAIN\name> -password <password> [-noadmin]
186. stsadm -o updatealerttemplates -url <url> [-filename <filename>] [-lcid <language>
187. stsadm -o updatefarmcredentials [-identitytype <configurableid/NetworkService>] [-userlogin <DOMAIN\name>] [-password <password>] [-local [-keyonly]]
188. stsadm -o upgrade {-inplace | -sidebyside} [-url <url>] [-forceupgrade] [-quiet] [-farmuser <farm user>] [-farmpassword <farm user password>] [-reghost] [-sitelistpath <sites xml file>]
189. stsadm -o upgradeformtemplate -filename <path to form template file> [-upgradetype <upgrade type>]
190. stsadm -o upgradesolution -name <Solution name> -filename <upgrade filename> [-time <time to upgrade at>] [-immediate] [-local] [-allowgacdeployment] [-allowcaspolicies] [-lcid <language>]
191. 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]
192. stsadm -o uploadformtemplate -filename <path to form template file>
193. stsadm -o userrole -url <url> -userlogin <DOMAIN\name> -role <role name> [-add] [-delete]
194. stsadm -o verifyformtemplate -filename <path to form template file>

Originally found on th following URL, thanks to Jose Barreto:
http://blogs.technet.com/josebda/archive/2008/03/15/complete-reference-of-all-stsadm-operations-with-parameters-in-moss-2007-sp1.aspx

Tiny SharePoint Calendar

Have you tried dropping a SharePoint month calendar on the home page of your SharePoint site? The result… not so cute: the calendar eats up half of the screen.


 In this post I am going to show how with the help of CSS you can shrink your SharePoint calendar and make it fit in the right column of a SharePoint page. The picture shows you the expected result.

So let’s start by dropping on our right column a monthly view of the calendar and a hidden Content Editor Web Part. In the source editor of the CEWP, paste the code below:


<style type="text/css">


/* Tiny Calendar */


/* Remove week blocks */
.ms-cal-weekempty {display:none;}
 .ms-cal-week {display:none;}
.ms-cal-weekB {display:none;}
.ms-cal-weekB {display:none;}

/* Shrink cells */
.ms-cal-workitem2B {display:none;}
.ms-cal-noworkitem2B {display:none;}
.ms-cal-nodataBtm2 {display:none;}
.ms-cal-todayitem2B {display:none;}
.ms-cal-workitem {font-size:0px;}
.ms-cal-muworkitem {font-size:0px;}
.ms-cal-noworkitem {font-size:0px;}
.ms-cal-nodataMid {font-size:0px;}
.ms-cal-todayitem {font-size:0px;}

/* thin out header */
.ms-cal-nav {display:none;}
.ms-cal-nav-buttonsltr {display:none;}
.ms-cal-navheader {padding:0px;spacing:0px;}
.ms-calheader IMG {width:15px;}

/* Abbreviate weekdays */
.ms-cal-weekday {letter-spacing:6px; width:22px; overflow: hidden;}

</style>

  
 
What this CSS does:

* height:

- Reduce the height of the calendar cells
- Reduce the height of the header

* width:

- Only keep the first letter of the weekday names
- Simplify the header options to just keep previous and next month
- Reduce the “bone” that forces the width of the header
- Remove the week boxes to the left of the calendar

Note that if you click on a day, SharePoint will open a full size day view of your calendar – I have chosen to keep this as the expected behavior. If you don’t like it you can simply deactivate the JavaScript that triggers the day view.

We now have our cute calendar that tells us that today is October 6 and that October 28th is a Tuesday.

The next step is to display the list items, so that I know for example that Halloween is on October 31st. This will be the object of part II. Of course, we’ll have to accept some constraints because of the reduced size of the calendar.

How about the bottom border. To get it, in the Web Part settings select:
Appearance -->Chrome type -->Border only.

Thanks to Christophe:
http://blog.pathtosharepoint.com/2008/10/06/tiny-sharepoint-calendar-1/