Daily Archives: June 3, 2009

Set Default Area for MS CRM User

Most of the time we want to change default area for all the crm user, but if number of users are very large then it’s a time consuming process, every body need to login and need to change his/her default page area.

There is not any supported method to chage it for all the users but we can do this by unsupported way :p

Inorder to change default page we need to update two columns in UserSettingsBase table

1. Homepagearea

2. Homepagesubarea

for example we want to make ‘Announcements’ as default page for all the user in that case just run this query under your organization database and reset IIS.

update UserSettingsBase set Homepagearea=’Workplace’,Homepagesubarea=’nav_news’

 Happy codding

Leave a comment

Filed under Sql Server & Ms CRM 4.0