#10314: No option given to choose the owner of our choice while creating schema in MS SQL server 2005

saima.alvi(*) reported 2013-10-04T06:38:13Z · last modified 2013-12-02T22:00:29Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	Future - .9

Aqua Data Studio 14.0.0-rc-42

Build #: 34276

Built on: 2013-Oct-02 12:24:18 PM

Issue: while creating the schema it takes dbo as the owner of the created schema ,

we cannot specify the owner of our choice.

Steps to reproduce:

1>schema-->Create schema

sript getting genereted is like this:

CREATE SCHEMA [newschema]

But in MS Sql server management studio when we create schema we get the schema owner option.

script getting generated there is:

USE [saima]

CREATE SCHEMA [newschema] AUTHORIZATION [Username]

Can we have the option to decide owner for the schema, being created,So it will not take default value.

All Comments (0) Change History