SQL Scripts – Clear Users and Activity Locks

June 19, 2010

Often times, when needing to perform maintenance in GP, your users will be logged out but GP still thinks they have documents open, batches they are working in, etc. This script will clear out off the user activity locks as well as their logins.

***This will remove ALL users from being logged in. Please make sure that users are indeed logged out before running this script.