We have the situation where GP users have been removed from the SQL database users but are still present in the User setup in GP. When you attempt to delete one of these IDs the system reports a SQL error and recommends that the SQL administrator be contacted.
My thoughts are that the user IDs exist in several tables in the Dynamics database. I have found references to one of the user IDs in the following Dynamics tables:
I haven't fully explored the records yet to see if simply deleting these (or some of these) entries would be enough to remove the IDs.
I was hoping that someone else had run into this situation and had a suggeston on how best to do this.
Thank you.
Tim
Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva
My thoughts are that the user IDs exist in several tables in the Dynamics database. I have found references to one of the user IDs in the following Dynamics tables:
Code:
[dbo].[ASIEXP98].[USERID]
[dbo].[SLB80000].[USERID]
[dbo].[STN41100].[PRNCODE]
[dbo].[STN41100].[USERID]
[dbo].[SY01400].[USERID]
[dbo].[SY01400].[USERNAME]
[dbo].[SY01402].[USERID]
[dbo].[SY01600].[USERID]
[dbo].[SY01990].[ScbDisplayName]
[dbo].[SY01990].[ScbOwnerID]
[dbo].[SY02000].[USERID]
[dbo].[SY01990].[ScbTargetStringOne]
[dbo].[SY07121].[USERID]
[dbo].[SY07130].[USERID]
[dbo].[SY07200].[USERID]
[dbo].[SY07210].[USERID]
[dbo].[SY08100].[USERID]
[dbo].[SY08120].[USERID]
[dbo].[SY08130].[USERID]
[dbo].[SY60100D].[USERID]
[dbo].[WDC51100].[USERID]
I haven't fully explored the records yet to see if simply deleting these (or some of these) entries would be enough to remove the IDs.
I was hoping that someone else had run into this situation and had a suggeston on how best to do this.
Thank you.
Tim
Tim Roop
"If you can do something about it, why waste time getting upset? If you can't do anything about it, why bother getting upset on top of it? -Shantideva