Real Life Dynamics User provides another SQL script, this time one that clears active users and activity locks.
SQL Scripts – Clear Users and Activity Locks
Install, Upgrade & AdminSQL & DataDevelopment & Integration
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.