I am receiving a daily download of a database and restoring it locally to do some custom reporting on. I have this working from Batch files running nightly.
The problem I have is that when I restore the database, it also overwrites the local users of the database which includes a user I added to access the tables from Visual Studio.
How can I restore a database, but leave the local users tables alone?
Thank you in advance.