1. 为保险起见, 请在操作前先备份SSP数据库.
2. 开启一个query窗口, 输入如下的SQL语句.
select p.PropertyName, v.propertyVal
from UserProfileValue v, UserProfile_Full f, PropertyList p
where f.email = 'administrator@yzdomain.com'
and v.propertyID = p.propertyid
and f.recordid = v.recordid
3. 结果示例如下:
