News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How to update business...

Microsoft Dynamics CRM (Archived)

How to update business unit of user which is owning millions of records in crm?

(0) Share

Report

Report

Posted on by Community Member

Hi team

I am stuck with a problem where I need to update the business unit of the user and he is currently owning 2 million records in CRM.

When I try updating, CRM throws SQL server time out error. Any suggestions?

Thanks,

Meet

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

David Jennaway 14,063 on at

Like (0)

Report

RE: How to update business unit of user which is owning millions of records in crm?

If you have CRM OnPremise, then you could substantially increase the OLEDBTimeout registry value, and try and make the change when the system is not busy
David Jennaway 14,063 on at

Like (0)

Report

RE: How to update business unit of user which is owning millions of records in crm?

If you've CRM OnPremise, you can increase the SQL timeout with the OLEDBTimeout registry value

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2

Martin Dráb 231,432 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans