1 Reply Latest reply on Jun 2, 2011 9:29 AM by gramsay

    Delete pre-existing user name from the Database

    Rookie

      I deleted a user from the LANDesk console and have decided to re add the user but get the following error message: Cannot isert duplicate key row in object 'dbo.tps_user' with unique index 'index$tps_user$name'.

       

      I have searched for the user under Analyst and End User and the are no where to be found so i assume that unique index is saved somewhere in the database causing me not to be able to duplicate that until it is deleted. Is there a script I can run to delete this from the database?