Seagate ST43401N/ND Informations techniques télécharger pdf (Page 84)

6-4 Implement: Making Required Database Administration Changes

If Your Current Version is 4.x Adaptive Server Enterprise 11.5

• Procedures that affect the master database cannot be run from

within a transaction. For example, you cannot run a procedure

such as this one from within a transaction:

if @@trancount > 0 print

• You may need to increase the open databases parameter. This

parameter must be set to at least the number of databases on your

system for the upgrade to succeed.

◆ WARNING!

If the open databases parameter is set to a value lower than the

number of databases on your system, the upgrade will fail.

• You need to develop a regular backup plan for sybsystemprocs.

Creating the System Stored Procedure Database

The Adaptive Server upgrade program automatically initializes a

database device and creates the stored procedure database at the

location that you indicate. The database size for release 11.5 is 60Mb.

See the installation guide to verify the size so that you can reserve

sufﬁcient space.

Moving User Stored Procedures

If you have your own stored procedures, you may want to move

them to the new sybsystemprocs database, although it is not required.

If you do decide to move them, follow these steps:

1. Add the database name and owner to any tables you reference

that exist in master.

2. Explicitly change the nondefault permissions on system

procedures.

3. Explicitly reference scripts that reference catalog tables as

master.dbo.<table_name>.

New create table Permission

In release 10.x and 11.x SQL Server, create table permission is explicitly

granted for all users on tempdb. This permission is granted at server

start-up time.

1 2 ... 79 80 81 82 83 84 85 86 87 88 89 ... 171 172

Pas de commentaire

Seagate ST43401N/ND Informations techniques Page 84