- Coding specific dates in SQL Server
- Date differences in SQL
- Getting the name of a month from the month number
- How to find all SQL tables with a column name
- Searching for strings in SQL Server using LIKE
- Examples of how to calculate different dates from Database Journal




Hi Victoria
Awesome, thanks u so much for ur reply.
Please mark me for the future questions.
Many thanks indeed…….
Hi Victoria
How to reset the password in GP 10.0 if the user is not logged off properly. When the administrator reset the password, message appears like “password has not been changed. The User is logged in”.
Do I have to reset password through Backend ‘ SQL Server’ and how it should be done. Please Explain……
Many Thanks
Sharmila,
I would recommend getting all users out of GP and running the following in SQL Server Management Studio:
Delete DYNAMICS..SY00800
Delete DYNAMICS..SY00801
Delete DYNAMICS..ACTIVITY
Delete TEMPDB..DEX_LOCK
Delete TEMPDB..DEX_SESSION
-Victoria
I was trying to upgrade our GP development server to SP2 and when I ran Utilities, it told me that someone was logged in, However, I already ran the SP2 install and couldn’t log in to GP to kick them out. I found several solutions to remove a user stuck in GP, including a couple of KB from Microsoft, but yours is the one that did the trick.