Seagate ST43401N/ND Informazioni Techniche Scaricare il pdf (Pagina 90)

6-10 Implement: Making Required Database Administration Changes

If Your Current Version is 4.x, 10.x or 11.0.x Adaptive Server Enterprise 11.5

Databases Online / Ofﬂine

Beginning with SQL Server 11.0, as part of the automatic upgrade

mechanism, a database has two states, online and ofﬂine.

Issuing a

load database command takes a database ofﬂine. If you have

scripts that load databases, you must add an

online database command

to your script to make the database available again after the load

sequence completes. A load sequence consists of:

•A

load database execution

• A complete set of

load transaction statements

isnull Function

Server objects containing the isnull function in their code may have to

be dropped and recreated. The

isnull issue affects only upgrades from:

• 10.0.2 through 10.0.2.6

• 11.0 through 11.0.2

For a description of the issue, see “isnull Function in Object Code” on

page 6-11 in the section “If Your Current Version is 4.x, 10.x or 11.0.x”.

If Your Current Version is 4.x, 10.x or 11.0.x

If your current version is SQL Server 11.0.x, begin with this section

and continue to the end of the chapter. If your current version is 4.x

or 10.x, continue with this section.

This section covers the following issues:

• New Reserved Words in Version 11.5 6-11

remote access allow remote access

remote connections number of remote connections

remote logins number of remote logins

T1204 (trace ﬂag) print deadlock information

T1603 (trace ﬂag) allow sql server async i/o

T1610 (trace ﬂag) tcp no delay

Table 6-3: Old and new conﬁguration parameter names

Old Name New Name

1 2 ... 85 86 87 88 89 90 91 92 93 94 95 ... 171 172

Nessun commento

Seagate ST43401N/ND Informazioni Techniche Pagina 90