Recreate Administrator SO user

02/14/2024 9:51 am EST

SET IDENTITY_INSERT SedonaMaster.dbo.SY_User ON 
INSERT INTO SedonaMaster.dbo.SY_User  
([User_Id],User_Code,User_Description,Password,First_Name,Last_Name,Middle_Init,Inactive,EMail_Address,CreateUsers,Password_Changed,Last_Login,Last_Password,Locked) 
SELECT 
2,'Administrator','MasterUser','','Sedona','Master','A','N','sedonamaster@sedonaoffice.com','Y','1899-12-30 00:00:00.000','1899-12-30 00:00:00.000','','N' 
SET IDENTITY_INSERT SedonaMaster.dbo.SY_User OFF

Was this article helpful?