The form submission cannot be processed because it exceeded the maximum length allowed by the Web administrator. Please resubmit the form with less data.

Step 1: Go to Central Administration - Application Management - Web Application - General Settings and change the Maximum Upload size.
Step 2: If step 1 does not resolve, ensure that you changed the maxRequestLength in the correct web.config. Double-check in IIS for the right virtual directory and the configuration file.
Step 3: Note that the MaxRequestLength is in KB. Do your calculations accordingly.
Step 4: There could more than one web.config files and it could be overridden. Check the appropriate one.
Step 5: refer this KB article.

1. SharePoint Central Administration: High Availability, Load Balancing, Security & General Recommendations
   XPS File: SharePoint Central Administration - High Availability, Load Balancing, Security & General Recommendations.xps (823.79 kb)
2. Scripted provisioning of multiple Central Admin web applications
   XPS File: Scripted provisioning of multiple Central Admin web applications.xps (237.35 kb)

Week : 7 (Sunday 07/02/2010 - Saturday 13/02/2010)
=CONCATENATE(INT(([Task Date]-DATE(YEAR([Task Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Task Date]),1,1)),"d")))/7)+1, " (", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dddd"), " ", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dd/mm/yyyy"), " - " , TEXT([Task Date]+7-WEEKDAY([Task Date]),"dddd"), " " , TEXT([Task Date]+7-WEEKDAY([Task Date]),"dd/mm/yyyy"), ")")

Week : 7
=INT(([Task Date]-DATE(YEAR([Task Date]),1,1)+(TEXT(WEEKDAY(DATE(YEAR([Task Date]),1,1)),"d")))/7)+1

Week : Sunday 07/02/2010
=TEXT([Task Date]-WEEKDAY([Task Date])+1,"dddd"), " ", TEXT([Task Date]-WEEKDAY([Task Date])+1,"dd/mm/yyyy")

Week : Saturday 13/02/2010
=TEXT([Task Date]+7-WEEKDAY([Task Date]),"dddd"), " ", TEXT([Task Date]+7-WEEKDAY([Task Date]),"dd/mm/yyyy")

*************************************************************************
Common Date Time formulas for Sharepoint – Calculated Fields

Get Week of the year
=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))+0.5-WEEKDAY(DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time])),2)+1

First day of the week for a given date:
=[Start Date]-WEEKDAY([Start Date])+1

Last day of the week for a given date:
=[End Date]+7-WEEKDAY([End Date])

First day of the month for a given date:
=DATEVALUE(“1/”&MONTH([Start Date])&”/”&YEAR([Start Date]))

Last day of the month for a given year (does not handle Feb 29). Result is in date format:
=DATEVALUE (CHOOSE(MONTH([End Date]),31,28,31,30,31,30,31,31,30,31,30,31) &”/” & MONTH([End Date])&”/”&YEAR([End Date]))

Day Name of the week : e.g Monday, Mon
=TEXT(WEEKDAY([Start Date]), “dddd”)
=TEXT(WEEKDAY([Start Date]), “ddd”)

The name of the month for a given date – numbered for sorting – e.g. 01. January:
=CHOOSE(MONTH([Date Created]),”01. January”, “02. February”, “03. March”, “04. April”, “05. May” , “06. June” , “07. July” , “08. August” , “09. September” , “10. October” , “11. November” , “12. December”)

Get Hours difference between two Date-Time :
=IF(NOT(ISBLANK([End Time])),([End Time]-[Start Time])*24,0)

Date Difference in days – Hours – Min format : e.g 4days 5hours 10min :
=YEAR(Today)-YEAR(Created)-IF(OR(MONTH(Today)<MONTH(Created),AND(MONTH(Today)=MONTH(Created), DAY(Today)<DAY(Created))),1,0)&” years, “&MONTH(Today)-MONTH(Created)+IF(AND(MONTH(Today)<=MONTH(Created),DAY(Today)<DAY(Created)),11,IF(AND(MONTH(Today)<MONTH(Created),DAY(Today)>=DAY(Created)),12,IF(AND(MONTH(Today)>MONTH(Created),DAY(Today)<DAY(Created)),-1)))&” months,“&Today-DATE(YEAR(Today),MONTH(Today)-IF(DAY(Today)<DAY(Created),1,0),DAY(Created))&” days”
OR
=IF(HOUR([Ending Date])>HOUR([Starting Date]),DATEDIF([Starting Date],[Ending Date],”d”)&” days “&HOUR([Ending Date]-[Starting Date])&” hours “,(DATEDIF([Starting Date],[Ending Date],”d”)-1)&” days “& HOUR([Ending Date]-[Starting Date])&” hours “)&MINUTE([Ending Date]-[Starting Date])&” minutes”

You can get Get more formulas from
http://office.microsoft.com/en-us/sharepointtechnology/HA011609471033.aspx

Reference

Taming the Elusive “Calculated Column” – Text and Data (Part V)

SharePoint 2007

Links

• http://www.jpy-tech.com/blog/archive.aspx#MOSS
• SharePoint 2007 Link List
•  

Files

• Office SharePoint Server 2007 Training Install Guide.docx (1.20 mb)
• SharePoint Interview questions.pdf (657.20 kb)

As a Site Owner, you have the ability to choose which permissions are associated with a particular permission level and/or add new permission levels to combine different sets of permissions. 

I recently ran into an issue on our internal support site where contributors were accidentally deleting pages list, files and content from the sites. I wanted our writers / members to have permissions to view, create and modify as needed. But I wanted to prevent them from deleting any files or content. In order to accomplish this, I created a custom permission level and removed ‘delete’ as an option. Following are the steps to create a custom permission level and then apply it to a user/group for a site.
 
PART 1:  Create a custom permission level on your site

1. Click Site Actions, then Site Settings.
2. Under Users and Permissions, click Advanced Permissions.
3. Click Settings, and then click Permission levels.
   On the Permission Levels page you can create a new level (where you manually choose all the appropriate fields) OR you can copy from an existing permission level from which you add/remove the specific permissions you want to make available to your users.  The following steps show how to COPY from an existing permission level.
4. Click the link for the existing permission level from which you will copy.  (In this example I clicked Contribute).
   On the Edit Permission Level page for the group, scroll down to the bottom and click Copy Permission Level.
   The page title should now read “Copy Permission Level … “.
5. Enter the Name and Description you want to give your new permission level in the corresponding boxes. (For example, I entered Name = Contribute – No Delete  in the Name box and Can view, add and update but not delete in the Description box.)
6. In the Permissions section, review each of the checked boxes and select or deselect any of the check boxes as appropriate for your new permission level.  For example, I deselected the check box for Delete Versions - Delete past versions of a list item or document.
7. When you are done editing the new permission level, click Create.
8. The new permission level will display in the list.
9. NEXT… apply your new permission level to specific users/groups on your site.

thanks

We use SharePoint in my company, our root site have company calendar and we have departmental SharePoint site, each of it contains their own departmental calendar. Our requirement is that in each department sites I need a web part which shows the global and departmental calendar events in one web part, and in root site I need to show all calendar including the root calendar in a web part.

Here am presenting my Globalized Calendar Web part v1.0

I will keep updating how I did this and the theory behind this and even source code later. Now am attaching the ".wsp" - GlobalCalendar.wsp (11.08 kb)

The following is a list of SharePoint URLs to get to commonly used administrative functions on a MOSS or WSS v3 site. Not all links listed on this page are accessible to all user levels of a site. This is a quick list for speedy reference as compared to tracking down links through the admin screens or for faster jumping around sites within a site collection.

thanks heathersolomon

Report Root Folder(%rsroot%) = "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services"

http://localhost/reports => "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager"

http://localhost/reportserver =>"C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer"

    * Edit Styles [%rsroot%\ReportServer\Styles]
         1. HtmlViewer.css
               1. Css Class = ".MenuBarBkGnd"
                  Type = "background-color"
         2. SP_Full.css
               1. Css Class = ".MenuBarBkGnd"
                  Type = "background-color"
         3. SP_Small.css
               1. Css Class = ".MenuBarBkGnd"
                  Type = "background-color"

    * Replace [%rsreports%\ReportManager\images\TOOLGRAD.GIF] with you image (keep imagename as "TOOLGRAD.GIF")

    * Edit Style [%rsroot%]\ReportManager\Styles]
         1. ReportingServices.css
         2. RSWebParts.css

Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Cause:

Anything that access database from SP requires at least the WSS_Medium security policy in the web.config file. If you receive a security message from the web part, it's usually the trust element in the web.config file.

Fix:

Open wss_mediumtrust.config & wss_minimaltrust.config usually (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\config\) look in your web.config file for the exact
path.

Find in wss_mediumtrust.config: <SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>

Copy and paste it in to the <SecurityClasses> node of wss_minimaltrust.config.

In the PermissionSet section of this configuration file, add the following:

Find in wss_mediumtrust.config: <IPermission class="SqlClientPermission" version="1" Unrestricted="true"/>

Copy and paste it in to the a <PermissionSet> node of wss_minimaltrust.config.

That about covers it.

OR

The application pool aslo has db owner permision to pubs.

◊ CSS Reference Chart for SharePoint 2007 (Microsoft Office SharePoint Server 2007 and Windows SharePoint Services v3) Link

◊ Image Reference Guides for SharePoint 2003 Link

◊ Page CSS Element Link

◊ Master Page Element Link

◊ How to: Create a Minimal Master Page Link | DefaultPPY.master (5.45 kb)

SharePoint Tips :

1. Hide the Site Settings Link in Portal?
   

   To quickly hide the Site Settings link in portal, add this to your custom style sheet:
   
   #SettingsOrReturnURL {display: none}
   
   All this does is change the display of the link itself to none.  So you aren't actually removing it from the code.