am trying to reset a user as she added several items to her home page and now her profile takes 15 minutes to load.
I tried deleting and recreating...but the problem persists.
I hid her home page...but she wants to use it.
Any tips on how to completely delete the user and or reset he home page??
With the user logged out you could turn on the Home Page with SQL. Substitute your user for <userwithmessedHP>
UPDATE SY08000 SET DISPHP=1 WHERE USERID='<userwithmessedHP>'
Then you could deactivate Content Panes. Substitute your user for <userwithmessedHP>
UPDATE SY08100 SET Visible=0 WHERE USERID='<userwithmessedHP>'
Then you could turn on the Content Panes 1 at a Time to figure out which one it is.
UPDATE SY08100 SET Visible=1 WHERE USERID='<userwithmessedHP>' AND SectionID=(see table below)
As an example, If it was QuickLinks....
Are you able to run this SQL Query? Substitute your user for <userwithmessedHP>
SELECT * FROM SY08140 WHERE USERID='<userwithmessedHP>'
This would show you all the Quick Links. Temporarily remove them from the user assuming no user called TEMP.
UPDATE SY08140 SET USERID='TEMP' WHERE USERID='<userwithmessedHP>'
See if the user can get in now. You should be able to reactivate the links one at a time if necessary, to discover the offender.
Yes TIM is correct, For your additional reference i mentioned the below link
Your link doesnt work...but nice site!
Other Microsoft Sites
I'm a Customer
I'm a Partner
Follow Microsoft Dynamics