Unlock Allscripts ProEHR Caregiver (TSQL)

There have been a couple instances where I’ve needed to unlock the system account, or various other caregiver accounts in Allscripts ProEHR.

Here’s how to do it via SQL; replace the bold username, system, to your needs.

update HPSITE.PROVIDERS set PROV_ACTIVITY=1, PROV_LOGINCOUNT=0 where PROV_LOGINNAME='system'