Example
/* creates a database for Alfresco, on SQLServer 2008- 2014 */
use master;
GO
CREATE DATABASE alfresco;
GO
/* creates a new LOGIN and associated User
use alfresco;
GO
CREATE LOGIN alfresco WITH PASSWORD = 'alfresco';
GO
use alfresco;
go
CREATE USER alfresco FOR LOGIN alfresco;
GO
/* Now try to add alfresco user to the db_owner Role
NOTICE: coinnect to alfresco database before
you can also connect as a local Windows user,
in order to successfully execute the followings: */
use alfresco;
GO
EXEC sp_addrolemember N'db_owner', N'alfresco';
GO
/* sets Isolation level */
ALTER DATABASE alfresco SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
/* creates and sets the alfesco schema as the default one */
use alfresco;
go
CREATE SCHEMA alfresco AUTHORIZATION alfresco;
GO
ALTER USER alfresco WITH DEFAULT_SCHEMA = alfresco;
GO
/* tests table creation */
drop table _buttamiVia_;
GO
create table _buttamiVia_
( id int not null );
GO
