New Transact-SQL functions  Changed system procedures

Chapter 3: New Features in Adaptive Server 12.5.2 and 12.5.3

New system procedures

Table 3-11 summarizes the new system procedures.

Table 3-11: 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





Copyright © 2005. Sybase Inc. All rights reserved. Changed system procedures

View this book as PDF