MSCRM Update User From Database

While updating the CRM database directly isn’t support sometimes it is the only way to work around the restrictions of the WUI. An example of when it is needed, is when there are duplicate users and CRM got confused.

<br />update SystemUserBase<br />set FullName = 'New FullName'<br />where FullName = 'Old FullName<br /> 
<br />--check queue name as well<br />select * from QueueBase<br />where name like '%name%'<br />

Posted in DevOps with : SQL Server