Hi.
I'm using MOSS2007 without AD, because we use workgroup.
I would like to activate email alerts when users modify, say, list items.
Where can I specify the email address of the users?
I've seen the tp_Email field at the dbo.UserInfo table on WSS_Content database.
Used this sql query:
--Query to get all the users in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.UserInfo.tp_ID,
dbo.UserInfo.tp_DomainGroup, dbo.UserInfo.tp_SiteAdmin, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Email
FROM dbo.UserInfo INNER JOIN
dbo.Webs ON dbo.UserInfo.tp_SiteID = dbo.Webs.SiteId
and I've got 869 rows. It lists the users that can access each site/subsite of the site collection. Do I have to fill the email field of each one of them so I can get email alerts enabled on that sites?
Can i use an Insert statement to fill the email address field based on tp_Title?
I need to get email alerts working, it is a very important feature.
thanks.
ramada
PS: must i switch to AD??