Share via

How to update 'tp_title' field of the UserInfo table of the SharePoint's Content Database from the OM code?

  • Article

Last week, I got this fascinating requirement. The requirement was to update the 'tp_title' field of the UserInfo table using OM Code API's. As we all SharePoint guys know that any query to the content database (even a select query, as it can affect the indexes) can put you in unsupported scenario with PSS guys.

So the only savior would be through OM code. Checking the table and the values in the table I found that the value can be easily set through the SPUser's name property. So the easy code piece for this would be:-

string strSiteCollectionUrl = "https://abc:1234"; //change it to your SiteCollectionUrl
SPSite site = new SPSite(strSiteCollectionUrl);
SPWeb web = site.OpenWeb();
SPUserCollection userColl = web.Users;
string strLoginName = @"XXX\qz19g4";
string newTitleName = "XXXX VVV- qz10g4";
SPUser user = userColl[strLoginName];
user.Name = strTitleName;
user.Update();

Comments

  • Anonymous
    July 27, 2008
    PingBack from http://stevepietrek.com/2008/07/27/links-7272008/

  • Anonymous
    December 03, 2008
    Great Blog this code has really helped me solve a problem I was working on.  Just a heads up, you have a variable named newTitleName but when you go to update you call strTitleName.  The other thing I noticed is you are not using the dispose method for your site or web.  I was told to always use that or a using statement. Here is the code I used, please let me know if I am doing this wrong.                      using (SPSite site = new SPSite(strSiteCollectionUrl))                    {                        site.AllowUnsafeUpdates = true;                        using (SPWeb web = site.OpenWeb())                        {                            web.AllowUnsafeUpdates = true;                            SPUser user = web.AllUsers[domainName];                            user.Name = newDisplayName;                            user.Update();                            user = null;                         }                    }

  • Anonymous
    December 03, 2008
    Hi AJ, Thanks for pointing the error regarding variable name - strTitleName. You are correct it should be newTitleName. And regarding the Disposing of SPWeb and SPsite objects, you have done it the right way. Cheers, Varun

  • Anonymous
    August 08, 2013
    Thanks for the details. Does it update the userinfo table at site collection level? Regards Roy Joyson