Table 3-11 summarizes the new system procedures.
System Procedure
Function
sp_webservices
Creates and manages the proxy tables used in the Consumer component of Web Services
sp_maplogin
Allows you to map external users to Adaptive Server logins
sp_helpmaplogin
Displays mapping information
sp_monitor
Adds the following parameters:
connection, (cpu | diskio | elapsed time), event, (summary | detail) , enable, disable, statement, (cpu | diskio | elapsed time), help
sp_dropalias
Adds the force parameter, which allows you to drop an alias even if it owns database objects.
sp_audit
Allows you to audit extended stored procedures.
sp_helptext
Truncates trailing spaces when displaying the source text from syscomments.
sp_ldapadmin
Creates an LDAP URL search string, lists an LDAP URL search string, or verifies an LDAP URL search string or login
View this book as PDF