Good day everyone
I want to change the company name automatically with an SQL Agent Job when I restore a copy of the live database to a test database.
The following work well and changes the name and display the new name after you have logged into the test company. The only problem I’m not sure where to change the company name there where you want to choose a company to logon, it still shows the live system's name and not the test system's name.
BEGIN UPDATE [SAP_XXX_TEST_FINANCE].[dbo].[OADM] SET CompnyName = 'z*** XXX TEST FINANCE ***' UPDATE [SAP_XXX_TEST_FINANCE].[dbo].[OUSR] SET WallPaper = '\\XXX-sap\B1_SHR\Pictures\Database_Wallpapers\Wallpaper_XXX_TEST_FINANCE.png' ,WllPprDsp = 2 END BEGIN UPDATE [SBO-COMMON].[dbo].[SRGC] SET cmpName = 'z*** XXX TEST FINANCE ***' WHERE dbName = 'SAP_XXX_TEST_FINANCE' END
Thank you in advance!