stsadm import failed with AllowAutomaticASPXPageIndexing error

Well i got stuck with this issue and the following hotfix helped to come over it :

http://support.microsoft.com/default.aspx?scid=kb;EN-US;957691

Server SQL Server evaluation period has expired.

In case you are trying to upgrade the Expired SQL server with retail SQL server follow these steps :

• Take Back up of the DB files (MDF and LDF)
• Unistall the expired SQL Server
• Install retail SQL Server
• Re-Attach old DB's

http://support.microsoft.com/kb/914158

SharePoint Designer for FREEE!!!!

Here it goes....


http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42

Calculated Column in SharePoint List

Am sure lot of you are searching for formulae which can we used in the Calculated column in SharePoint list. If yes, you are in right place .

Here are some useful links :
http://office.microsoft.com/en-us/sharepointtechnology/CH100650061033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/CH101032701033.aspx
http://office.microsoft.com/en-us/sharepointtechnology/HA101054791033.aspx?pid=CH100650061033#4

STSADM: The farm is unavailable

This error pops up when the user running the command doesn't have access to SQl Server , make sure you are using admin account(preferable) in order to run stsadm tool.

Alert Not Working

Try this :

• stsadm.exe -o setproperty -propertyname job-immediate-alerts -propertyvalue "every 1 minutes between 0 and 59" -url "http://SiteName"
• stsadm.exe -o setproperty -propertyname alerts-enabled -propertyvalue "true" -url "http://SiteName"

CAML Query Builder

Life gets's so much easier when intellect people think of tool which developer community actually needs , here is the one tool which actually has the potential to give you that extra time which you spend writing long CAML query :-):

http://www.u2u.be/res/Tools/CamlQueryBuilder.aspx

Unable to add selected web part(s).

ERROR :

<WebpartName>: The file is not checked out. You must first check out this document before making changes.

Scenario with Solution

While trying to add webpart to the page , i received the above error. After some minutes i got the culprit .

1) Even on clicking "Edit Page" my file was not checking out , so i had to check out my webform using sharePoint designer. This solved my intial issue of adding web part .

2) Now question was , Why the "Edit Page" is not chekcing out my page , well it was no brainer . Publishing feature in my Site Feature was not active.

ENJOY!!