• You should not put any user tables or other items in the master database. Use your own database for your own items.

    Also it is worth looking at SQL 2012 Local Database. This installs a few DLLs and allows you to do simple SQL on a SQL Server database file. It is the lightest weight version of SQL Server that is available. However, it does need exclusive use of the database file. If you want to have shared use then you will need a full SQL Express install.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara