Toad World® Forums

Toad 5.5 Object Explorer (View_Details on Database) ommision of Schema info.)

When attempting to script out a database creation from the Object Explorer /
view details on a database that has schemas, the application doesn’t
script out the creation of schema, which it should.

Therefore, this is a bug or a new feature depending on your point of view.

I have included the script into the table on the left and the corrective action
created from the DDL creation process.

Please let me know if you think this is an error so that I can report same to
support@quest.com

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype

View Details of a Database – Send to editor

Corrective Script generated from DDL creation where Schema was the only option

/****** Object: Database [GCMA_CISMHS_STAGE] Script Date: 8/16/2011 11:49:23 AM
******/

USE [master] ;

GO

CREATE DATABASE [GCMA_CISMHS_STAGE]

ON

PRIMARY

( NAME = N ‘GCMA_STAGE’ , FILENAME = ‘E:\MSSQL\Data\GCMA_STAGE.mdf’ , SIZE =
8261MB, MAXSIZE = 20000 MB, FILEGROWTH = 200MB )

LOG ON

( NAME = N ‘GCMA_STAGE_log’ , FILENAME = ‘F:\MSSQL\Logs\GCMA_STAGE_log.ldf’ ,
SIZE = 3671MB, MAXSIZE = 2097152 MB, FILEGROWTH = 10 % )

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET COMPATIBILITY_LEVEL = 100 ;

GO

IF ( 1 = FULLTEXTSERVICEPROPERTY ( ‘IsFullTextInstalled’ ))

begin

EXEC [GCMA_CISMHS_STAGE].[sys].[sp_fulltext_database] @action = ‘enable’

end ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ANSI_NULL_DEFAULT OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ANSI_NULLS OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ANSI_PADDING OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ANSI_WARNINGS OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ARITHABORT OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET AUTO_CLOSE OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET AUTO_CREATE_STATISTICS ON ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET AUTO_SHRINK OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET AUTO_UPDATE_STATISTICS ON ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET CURSOR_CLOSE_ON_COMMIT OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET CURSOR_DEFAULT GLOBAL ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET CONCAT_NULL_YIELDS_NULL OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET NUMERIC_ROUNDABORT OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET QUOTED_IDENTIFIER OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET RECURSIVE_TRIGGERS OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET DISABLE_BROKER ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET AUTO_UPDATE_STATISTICS_ASYNC OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET DATE_CORRELATION_OPTIMIZATION OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET TRUSTWORTHY OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET ALLOW_SNAPSHOT_ISOLATION OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET READ_COMMITTED_SNAPSHOT OFF ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET PARAMETERIZATION SIMPLE ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET READ_WRITE ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET RECOVERY SIMPLE ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET MULTI_USER ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET PAGE_VERIFY CHECKSUM ;

GO

ALTER DATABASE [GCMA_CISMHS_STAGE] SET DB_CHAINING OFF ;

GO

USE [GCMA_CISMHS_STAGE] ;

GO

GRANT CONNECT TO [gcmastage_user]

GO

GRANT CONNECT TO [gcmauser]

GO

GRANT CONNECT TO [gcmauser2]

GO

–end

USE [GCMA_CISMHS_STAGE]

GO

GO

CREATE SCHEMA [CIS]

AUTHORIZATION [gcmauser2]

GO

CREATE SCHEMA [db_accessadmin]

AUTHORIZATION [db_accessadmin]

GO

CREATE SCHEMA [db_backupoperator]

AUTHORIZATION [db_backupoperator]

GO

CREATE SCHEMA [db_datareader]

AUTHORIZATION [db_datareader]

GO

CREATE SCHEMA [db_datawriter]

AUTHORIZATION [db_datawriter]

GO

CREATE SCHEMA [db_ddladmin]

AUTHORIZATION [db_ddladmin]

GO

CREATE SCHEMA [db_denydatareader]

AUTHORIZATION [db_denydatareader]

GO

CREATE SCHEMA [db_denydatawriter]

AUTHORIZATION [db_denydatawriter]

GO

CREATE SCHEMA [db_owner]

AUTHORIZATION [db_owner]

GO

CREATE SCHEMA [db_securityadmin]

AUTHORIZATION [db_securityadmin]

GO

CREATE SCHEMA [MHS]

AUTHORIZATION [gcmauser2]

GO

image001.gif

image002.jpeg

Hank,

why do you think SCHEMAs should be a part of database creation script?

Valentin, I am going to take this discussion off-line with you for the time
being.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image002.jpeg

Valentin, I am going to take this discussion off-line with you for the time
being.

Hank Freeman

Senior SQL Server DBA/Data & Systems Architect

hfreeman@msn.com

678-414-0090 my cell Primary

hank.freeman50 via Skype
image001.gif