I had to change hostname to conform to new employer policy. I have about 4 DBs locally in MSSQL lite. They still work. The apps that use them are working just fine. I ran...
SELECT @@SERVERNAME AS 'Old Server Name' EXEC xp_getnetname
and it came up with the correct old server name and the correct new name in the results. I found an article that drops the old server name but I'm worried that my DBs which are working will be dropped. Is there a way to update the old such that my DBs will now be accessible. I tried just changing the server name to the old one, but my user has also changed. The employer changed our domain and accounts and gave us new hostnames. And I always used Windows Auth to authenticate.
How can I find my old DBs and get into them so I can do maintenance?