alfresco
T-SQL-Skript zum Erstellen der Alfresco-Datenbank in SQLServer 2008 - 2014

Einführung

Bemerkungen

T-SQL_script_4_alfresco

/* 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