ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-49
Examples
ON database-device = size
is not supported. In the NonStop ODBC Server, this clause is ignored. No error
messages are generated.
Examples
The following statement creates a NonStop SQL/MP catalog PERSNL on the disk
volume DISK01 on the node called TEST:
create database test_disk01_persnl
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, CREATE DATABASE differs from the
SQL Server implementation in the following ways:
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Can CREATE
DATABASE be inside a
transaction?
No Yes
See DDL Statements Allowed
in User-Defined Transactions
on page 4-3.
Are specific permissions
needed?
Yes, you must have permission
to create a database on the
server.
Yes, you need the appropriate
Guardian and Safeguard
permissions. The user must
have the ability to update the
USAGES and CATALOGS
tables in the system catalog,
and to create files on the
target subvolume.
Is a specific database
required?
Yes, you must be in the
MASTER database to create a
database.
No
Who owns the database? The user who creates it. The user who creates it,
unless the specified
subvolume already contains a
catalog. In that case, the
database owner is the
Guardian name of the owner
of the NonStop SQL/MP
catalog.
What security does the
database have?
Only the database owner can
access the database. The
owner can grant other users
permission to use the
database.
Uses file-system security,
which is obtained from the
default permissions
associated with the user’s
logon name