Bookshelf Home | Contents | Index | Search | PDF

Siebel Server Installation Guide for Microsoft Windows > Sample Database Creation Scripts >

MS SQL Sample Script

---

Edit the sample MS SQL database creation script in any way to suit your site requirements and to automate your database instance creation. After editing, the script can be run using the Query Analyzer, ISQL, or OSQL. To execute this script, you must use the sa user ID for Microsoft SQL Server.

Sample Database Instance Creation Script (crdb_blank.sql)

Edit and run the script crdb_blank.sql to fit your site requirements and to create an MS SQL database instance.

____________________________________________________________________

-- File: crdb_blank.sql

-- Purpose: Sample script demonstrates how to create a MSSQL db for Siebel applications

-- Execution: Run the script from Query Analyzer

--

-- Note:

-- 1. Replace BLANKDB with the Siebel Database Server name.

-- 2. Edit values between double brackets with the appropriate values for your installation.

Use master;

create database BLANKDB

on primary (name = 'DATA',

filename = '<<d:\mssql2000\data\BLANKDB_DATA>>.MDF')

log on (name = 'LOG',

filename = '<<full path for log file>>.LDF')

alter database BLANKDB

modify file

(NAME = 'DATA',

FILEGROWTH = 10MB);

alter database BLANKDB

modify file

(NAME = 'DATA',

MAXSIZE = UNLIMITED);

alter database BLANKDB

modify file

(NAME = 'LOG',

FILEGROWTH = 10MB);

alter database BLANKDB

modify file

(NAME = 'LOG',

MAXSIZE = UNLIMITED);

--This section is similar to the grantuser.sql script. Run this

--portion of the MS SQL sample database creation script to grant

--priveleges to users. To execute either the grantuser.sql script or

--the MS SQL sample database creation script, you must use the sa

--user ID or role for MS SQL server.

--Add logins

--Update passwords as necessary. SADMIN and SIEBEL are assumed.

sp_addlogin SADMIN, <<SADMIN PASSWORD>>, BLANKDB;

sp_addlogin SIEBEL, <<SIEBEL PASSWORD>>, BLANKDB;

use BLANKDB;

sp_dropuser SADMIN;

sp_dropuser SIEBEL;

sp_addrole SSE_ROLE;

sp_adduser SADMIN, <<SADMIN PASSWORD>>, SSE_ROLE;

sp_changedbowner SIEBEL;

grant create procedure to SSE_ROLE;

Bookshelf Home | Contents | Index | Search | PDF