SQL - Create Database as a specific user
Posted on 2012-09-04
How would I set it so that when I create a database, that a specific user have permission to it. When I create the database file mdf and ldf, it set a user "SYSTEM" as the only one having access. Once I go and add myself, I can then copy, move, or delete the file. I don't want to have to do that everytime I create a database. Is there a way to set it up so that I have access to the MDF and LDF file?