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 group 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_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 specified 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_disable_auditing_type system procedure
  Disables auditing of specific events.
• sa_disk_free_space system procedure
  Reports information about space available for a dbspace, 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_flush_cache system procedure
  Empties all pages for the current database in the database server cache.
• sa_make_object system procedure
  Ensures that a skeletal instance of an object exists before executing an ALTER statement.
• 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_validate system procedure
  Validates all, or parts, of a database.
• sa_verify_password system procedure
  Validates the password of the current user.
• sp_login_environment system procedure
  Sets connection options when users log in.
• 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_tsql_environment system procedure
  Sets connection options when users connect from jConnect or Open Client applications.