Tuesday, December 14, 2010

How to change e-mail address to a MOSS 2007 user

You can find the users e-mail address information for MOSS 2007 in the UserInfo table on the Content Database for your MOSS 2007 site. The field is tp_Email.

Using a simple SQL UPDATE statement you can change the value for the e-mail. Be careful to select only the record you need.