Hide Workflow Link on Item Context Menu for Document List

1. Open CORE.JS on C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033
2. find the words: function AddDocLibMenuItems(m, ctx)
3. under the function, find words: AddWorkflowsMenuItem(m, ctx);
4. comment that out. or Add if (ctx.ListTitle != "Test Document") to focus on some list title.
5. Save it of course.

Set up SQL mail on SQL Server 2005

Solve the problem on "Enable the use of 'Database Mail XPs' by using sp_configure"

USE Master
GO
sp_configure 'show advanced options', 1
GO
reconfigure with override
GO
sp_configure 'Database Mail XPs', 1
GO
reconfigure
GO
sp_configure 'show advanced options', 0
GO

User for Imcomplete Survey

Hi,
I cannot find the answer to open the imcomplete survey. Some people say they can see the imcomplete response if the site template is TEAM site. But I still canot see it.
The only thing I can see is the user list with imcomplete survey and SQL is like:

select a2.nvarchar3, a2.nvarchar1, a2.nvarchar2, a2.nvarchar10, a2.nvarchar14, a1.tp_CheckoutUserId
from AllUserData a1
inner join AllUserData a2
on a1.tp_CheckoutUserId = a2.tp_ID
where a1.tp_ListId = 'A841EA21-20EC-4B79-AAC0-F1AD25F6278E'
and a1.tp_CheckoutUserId is not null and a2.tp_ContentType = 'Person' order by a2.nvarchar1

How to find ListTemplateId from a list

Try to create a new List.
Select the list template you want to create.
Before you click Create Button, see the URL.
It should be something like http://site/_layouts/new.aspx?NewPageFilename=TEST%2Estp&FeatureId={00bfea71-3a1d-41d3-a0ee-651d11570120}&ListTemplate=120
and List Template ID is there.

PWA: Setting User and Group Permission

IT'S NOT UNDER SITE ACTIONS/SITE SETTING

You should see the "Server Settings" on the left hand side if you have right to see it.

Install Caml dll

Copy CodeArt.SharePoint.CamlQuery.dll to folder C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
and GAC place.

VM Ware: Share File between host and virtual

1. Open vmware;
2. Click menu "VM", then select "Settings";
3. Then click "Options" in the new window, and you will see an option "Shared folders Enabled" ;
4. Select it and add some folders;
5. OK, end.

SharePoint 2007: Error on add attachment

If getting error:
Failed to get value of the "Attachments" column from the "Attachments" field type control. See details in log. Exception message: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)..
You have double web parts using the same attachmentUpload. Check in html "view source", you will find two span tags "part1" or two attachment row. Please "Close" one web part.

C# String to Char

string newlineKeyword = ".";
char spliterChar = char.Parse(newlineKeyword);

Open pane tool section

Use this:
javascript:MSOTlPn_ShowToolPane2Wrapper('Edit', this, '" + this.ID + "')