Filter
Top Products
Upgrading Backup Server, Monitor Server, and XP Server
76 Adaptive Server Enterprise
1> sp_audit "security", "all", "all", "on"
2> go
1> sp_audit "dbcc", "all", "all", "on"
2> go
For more information, see the Reference Manual.
Special considerations for threshold procedures for audit segments
If your installation used a threshold procedure to archive the sysaudits table
using T-SQL similar to the following example:
INSERT MyPre15SysAuditHistoryTable SELECT * FROM
sysaudits_0n
Where n corresponds to the sysaudits table number 1 – 8 and
MyPre15SysAuditHistoryTable is a table defined prior to Adaptive Server
version 15.0.2, then you must alter MyPre15SysAuditHistoryTable to add a
nodeid column using the following command:
alter table MyPre15SysAuditHistoryTable
add nodeid tinyint NULL
See the Reference Manual for system tables sysaudits01 through sysaudits08
for further details about the
sysaudits tables.
Shutting down SySAM servers
Shut down the old SySAM servers if they are no longer used by earlier versions
of Adaptive Servers.
Upgrading Backup Server, Monitor Server, and XP
Server
Before you can upgrade Backup or Monitor Server, you must upgrade
Adaptive Server.