Tuesday, February 19, 2008
12:58 PM | 
Posted by
David E. Patrick
I've been asked this a few times, and so, I thought a post might be in order.
If you ever get "locked" out of the system, i.e. something crashes and then you cannot log back in, this little piece of SQL will kick everyone off ( or,more specifically, it will delete everyone's login from the activity table):
DELETE FROM DYNAMICS.dbo.ACTIVITY
In Great Plains 7.5 and below, this was a life saver. You could also do individual users like so:
DELETE FROM DYNAMICS.dbo.ACTIVITY WHERE userid='username'
In Great Plains 9 and above, they now have a nice window that pops up that lets you delete yourself, if you happen to already be logged in, so the theory is that this script is no longer necessary.
But wait!
That assumes that that little window will still pop up after a crash. And sometimes, after a crash, all bets are off, so I still keep this little guy handy, just in case...
If you ever get "locked" out of the system, i.e. something crashes and then you cannot log back in, this little piece of SQL will kick everyone off ( or,more specifically, it will delete everyone's login from the activity table):
DELETE FROM DYNAMICS.dbo.ACTIVITY
In Great Plains 7.5 and below, this was a life saver. You could also do individual users like so:
DELETE FROM DYNAMICS.dbo.ACTIVITY WHERE userid='username'
In Great Plains 9 and above, they now have a nice window that pops up that lets you delete yourself, if you happen to already be logged in, so the theory is that this script is no longer necessary.
But wait!
That assumes that that little window will still pop up after a crash. And sometimes, after a crash, all bets are off, so I still keep this little guy handy, just in case...
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment