GPv6-Kill User activity

[markajem]

GP v6

On our test system we seem to be having an issue with logging into GP. My post is not about that issue but the fact that when we attempt to log in on the test system GP is reporting back a stored procedure error. After this error clears it locks the user and then the next time we try to log in again with that username it says the user is already logged in. So no matter what username we use it locks it. Would you know what datafile and field I can go to with SQL qry analyser and unlock the user that way until we solve our problem with the stored procedure during login time. I will run out of usernames soon to try solving my log in error.

Thanks for any help

 

[markajem]

Sorry, please ignore this post. I tried searching the forum for this and could not find anything and that is why I posted it. I just realized I misspelled my search keywords and that is why I did not find it. Hey, what you want it is Monday morning

Dynamics> Activity datafile. EManager, return all rows and delete the user.

 

[klewis10367]

Use the Activity table under the dynamics database.