Tuesday, June 09, 2009

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

Tuesday, June 02, 2009

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.