Alphabetical List of Catalog Stored Procedures

Catalog store stored procedures return result sets displaying database server, database, and connection properties in tabular form.

These procedures are owned by the dbo user ID. The PUBLIC role has EXECUTE permission on them.

• sa_ansi_standard_packages system procedure
  Returns information about the non-core SQL extensions used in a SQL statement.
• sa_audit_string system procedure
  Adds a string to the transaction log.
• sa_char_terms System Procedure
  Breaks a CHAR string into terms and returns each term as a row along with its position.
• sa_checkpoint_execute system procedure
  Allows the execution of shell commands during a checkpoint.
• sa_conn_activity system procedure
  Returns the most recently-prepared SQL statement for each connection to the indicated database on the server.
• sa_conn_info system procedure
  Reports connection property information.
• sa_conn_list system procedure
  Returns a result set containing connection IDs.
• sa_conn_properties system procedure
  Reports connection property information.
• sa_db_info system procedure
  Reports database property information.
• sa_db_properties system procedure
  Reports database property information.
• sa_describe_shapefile System Procedure
  Describes the names and types of columns contained in an ESRI shapefile. This system feature is for use with the spatial data features.
• sa_dependent_views system procedure
  Returns the list of all dependent views for a given table or view.
• sa_disable_auditing_type system procedure
  Disables auditing of specific events.
• sa_disk_free_space system procedure
  Reports information about space available for a transaction log, transaction log mirror, and/or temporary file.
• sa_enable_auditing_type system procedure
  Enables auditing and specifies which events to audit.
• sa_eng_properties system procedure
  Reports database server property information.
• sa_external_library_unload System Procedure
  Unloads an external library.
• sa_flush_cache system procedure
  Empties all pages for the current database in the database server cache.
• sa_get_user_status system procedure
  Allows you to determine the current status of users.
• sa_get_ldapserver_status System Procedure
  Determines the current status of the LDAP server configuration object.
• sa_list_external_library system procedure
  Lists the external libraries currently loaded in the server.
• sa_locks System Procedure
  Displays all locks in the database.
• sa_make_object system procedure
  Ensures that a skeletal instance of an object exists before executing an ALTER statement.
• sa_nchar_terms System Procedure
  Breaks an NCHAR string into terms and returns each term as a row along with its position.
• sa_performance_diagnostics System Procedure
  Returns a summary of request timing information for all connections when the database server has request timing logging enabled.
• sa_report_deadlocks System Procedure
  Retrieves information about deadlocks from an internal buffer created by the database server.
• sa_rowgenerator system procedure
  Returns a result set with rows between a specified start and end value.
• sa_server_option System Procedure
  Overrides a server option while the server is running..
• sa_set_http_header system procedure
  Permits a web service to set an HTTP response header.
• sa_set_http_option system procedure
  Permits a web service to set an HTTP option for process control.
• sa_table_page_usage system procedure
  Reports information about the page usage of database tables.
• sa_text_index_stats System Procedure
  Returns statistical information about the TEXT indexes in the database.
• sa_text_index_vocab System Procedure
  Lists all terms that appear in a TEXT index, and the total number of indexed values in which each term appears.
• sa_validate system procedure
  Performs a checksum validation on all, or parts, of a database.
• sa_verify_password system procedure
  Validates the password of the current user.
• sp_alter_secure_feature_key System Procedure
  Alters a previously-defined secure feature key by modifying the authorization key and/or the feature list.
• sp_auth_sys_role_info System Procedure
  Generates a report which maps authorities to corresponding system roles and role id. This procedure returns a row for each authority.
• sp_create_secure_feature_key System Procedure
  Creates a new secure feature key.
• sp_displayroles System Procedure
  Displays all roles granted to a user-defined role or a user, or displays the entire hierarchical tree of roles.
• sp_drop_secure_feature_key System Procedure
  Deletes a secure feature key.
• sp_expireallpasswords system procedure
  Immediately expires all user passwords.
• sp_list_secure_feature_keys System Procedure
  Returns information about the contents of a directory.
• sp_login_environment system procedure
  Sets connection options when users log in.
• sp_objectpermission System Procedure
  Generates a report on object permissions granted to the specified role, or user name, or the object permissions granted on the specified object or dbspace.
• sp_proc_priv system procedure
  Generates a report of the minimum system privileges required to run a stored procedure and pass the permission check for the procedure.
• sp_remote_columns system procedure
  Produces a list of the columns in a remote table, and a description of their data types.
• sp_remote_exported_keys system procedure
  Provides information about tables with foreign keys on a specified primary table.
• sp_remote_imported_keys system procedure
  Provides information about remote tables with primary keys that correspond to a specified foreign key.
• sp_remote_primary_keys system procedure
  Provides primary key information about remote tables using remote data access.
• sp_remote_tables system procedure
  Returns a list of the tables on a server.
• sp_servercaps system procedure
  Displays information about a remote server's capabilities.
• sp_sys_priv_role_info System Procedure
  Generates a report to map a system privilege to the corresponding system role. A single row is returned for each system privilege.
• sp_tsql_environment system procedure
  Sets connection options when users connect from jConnect or Open Client applications.
• sp_use_secure_feature_key System Procedure
  Enables an existing secure feature key.