Re: deleting users from database - crm 3.0

[Matt Parks]

I believe the timeframe on teh DeletionService is Minutes, not seconds.
This isn't something that you would typically want running that frequently
(by default it's 2 hours). Users aren't deletable objects by default. So,
it is completely possible that the deletionservice isn't even looking at
them. Also, there are a large amount of records that are tied to the user
table. So, even if the service was trying to delete the records, there is a
good chance it is hitting a FK violation in the process.

--

Matt Parks
MVP - Microsoft CRM

"axmann" <axm...@discussions.microsoft.com> wrote in message
news:7A06F581-0B3A-47B4...@microsoft.com...
We have some users who are disabled and I would like to completely remove
them from the CRM database.
I set the deletionstatecode on the systemuserbase table=2. Shouldn't that
work? Also, I have the "DSDeleteRunInterval" in the registry to 300. That's
in seconds correct? If so, it's been over 5 minutes and the record hasn't
been deleted.

Any help would be great,
Thanks

[DerekH]

I would also add that tinkering at this level is completely unsupported
and even dangerous if you dont completely understand what you are
doing, and MS will not support you for these low level modifications.
The general rule is that users, once in CRM cannot be deleted, only
de-activated.