Chapter 14 System Procedures and Functions
963
System and catalog stored procedures
System and catalog stored procedures are owned by the user ID
dbo
. Some
of these procedures are for internal system use. This section documents only
those not intended solely for system and internal use. You cannot call
external functions on Windows CE.
sa_audit_string system procedure
Adds a string to the audit log.
sa_audit_string (
string
)
DBA authority required
None
"AUDITING option" on page 172
"Auditing database activity" on page 778 of the book ASA User’s Guide
If auditing is turned on, this system procedure adds a comment into the audit
log. The string can be a maximum of 200 bytes long.
The following call adds a comment into the audit log:
call sa_audit_string( ’Auditing test’ )
sa_check_commit system procedure
Checks for outstanding referential integrity violations before a commit.
sa_check_commit ( out
tname
varchar( 128 ), out
keyname
varchar( 128 ) )
None
None
"WAIT_FOR_COMMIT option" on page 217
"CREATE TABLE statement" on page 466
If you have the database option WAIT_FOR_COMMIT set to ON, or if a
foreign key is defined using CHECK ON COMMIT in the CREATE TABLE
statement, you can update the database in such a way as to violate referential
integrity, as long as these violations are resolved before the changes are
committed.
Function
Syntax
Permissions
Side effects
See also
Description
Examples
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...