It's useful to have a T-SQL script for creating and configuring a new database and user for Alfresco Installation purposes. It's boring and time-consuming to jump around many pages on MSDN.
I provide the script hereafter:
Guidelines for preparing Alfresco Instalation to a SQLServer database, can be read here: