System Stored Procs
| sp_activeroles | sp_activeroles - Displays all active roles. sp_activeroles [expand_down] |
| sp_add_resource_limit | sp_add_resource_limit - Creates a limit on the number of server resources that can be used by an Adaptive Server login and/or an application to execute a query, query batch, or transaction. sp_add_resource_limit name, appname, rangename, limittype, limitvalue [, enforced [, action [, scope ]]] |
| sp_add_time_range | sp_add_time_range - Adds a named time range to an Adaptive Server. sp_add_time_range name, startday, endday, starttime, endtime |
| sp_addalias | sp_addalias - Allows an Adaptive Server user to be known in a database as another user. sp_addalias loginame, name_in_db |
| sp_addauditrecord | sp_addauditrecord - Allows users to enter user-defined audit records (comments) into the audit trail. sp_addauditrecord [text] [, db_name] [, obj_name] [, owner_name] [, dbid] [, objid] |
| sp_addaudittable | sp_addaudittable - Adds another system audit table after auditing is installed. sp_addaudittable devname |
| sp_addengine | sp_addengine - Adds an engine to an existing engine group or, if the group does not exist, creates an engine group and adds the engine. sp_addengine engine_number, engine_group |
| sp_addexeclass | sp_addexeclass - Creates or updates a user-defined execution class that you can bind to client applications, logins, and stored procedures. sp_addexeclass classname, priority, timeslice, engine_group |
| sp_addextendedproc | sp_addextendedproc - Creates an extended stored procedure (ESP) in the master database. sp_addextendedproc esp_name, dll_name |
| sp_addexternlogin | sp_addexternlogin - Creates an alternate login account and password to use when communicating with a remote server through Component Integration Services. sp_addexternlogin server, loginname, externname [, externpassword] |
| sp_addgroup | sp_addgroup - Adds a group to a database. Groups are used as collective names in granting and revoking privileges. sp_addgroup grpname |
| sp_addlanguage | sp_addlanguage - Defines the names of the months and days for an alternate language and its date format. sp_addlanguage language, alias, months, shortmons, days, datefmt, datefirst |
| sp_addlogin | sp_addlogin - Adds a new user account to Adaptive Server. sp_addlogin loginame, passwd [, defdb [, deflanguage [, fullname]]] |
| sp_addmessage | sp_addmessage - Adds user-defined messages to sysusermessages for use by stored procedure print and raiserror calls and by sp_bindmsg. sp_addmessage message_num, message_text [, language] [, with_log] [, replace] |
| sp_addobjectdef | sp_addobjectdef - Specifies the mapping between a local table and an external storage location. sp_addobjectdef tablename, "objectdef" [,"objecttype"] |
| sp_addremotelogin | sp_addremotelogin - Authorizes a new remote server user by adding an entry to master.dbo.sysremotelogins. sp_addremotelogin remoteserver [, loginame [, remotename] ] |
| sp_addsegment | sp_addsegment - Defines a segment on a database device in a database. sp_addsegment segname, dbname, devname |
| sp_addserver | sp_addserver - Defines a remote server, or defines the name of the local server. sp_addserver lname [, class [, pname]] |
| sp_addthreshold | sp_addthreshold - Creates a threshold to monitor space on a database segment. When free space on the segment falls below the specified level, Adaptive Server executes the associated stored procedure. sp_addthreshold dbname, segname, free_space, proc_name |
| sp_addtype | sp_addtype - Creates a user-defined datatype. sp_addtype typename, phystype [(length) | (precision [, scale])] [, "identity" | nulltype] |
| sp_addumpdevice | sp_addumpdevice - Adds a dump device to Adaptive Server. sp_addumpdevice {"tape" | "disk"}, logicalname, physicalname [, tapesize] |
| sp_adduser | sp_adduser - Adds a new user to the current database. sp_adduser loginame [, name_in_db [, grpname]] |
| sp_altermessage | sp_altermessage - Enables and disables the logging of a system-defined or user-defined message in the Adaptive Server error log. sp_altermessage message_id, parameter, parameter_value |
| sp_audit | sp_audit - Allows a System Security Officer to configure auditing options. sp_audit option, login_name, object_name [,setting] |
| sp_autoconnect | sp_autoconnect - Defines a passthrough connection to a remote server for a specific user, which allows the named user to enter passthrough mode automatically at login. sp_autoconnect server, {true|false} [, loginame] |
| sp_bindcache | sp_bindcache - Binds a database, table, index, text object, or image object to a data cache. sp_bindcache cachename, dbname [, [ownername.]tablename [, indexname | "text only"]] |
| sp_bindefault | sp_bindefault - Binds a user-defined default to a column or user-defined datatype. sp_bindefault defname, objname [, futureonly] |
| sp_bindexeclass | sp_bindexeclass - Associates an execution class with a client application, login, or stored procedure. sp_bindexeclass "object_name", "object_type", "scope", "classname" |
| sp_bindmsg | sp_bindmsg - Binds a user message to a referential integrity constraint or check constraint. sp_bindmsg constrname, msgid |
| sp_bindrule | sp_bindrule - Binds a rule to a column or user-defined datatype. sp_bindrule rulename, objname [, futureonly] |
| sp_cacheconfig | sp_cacheconfig - Creates, configures, reconfigures, and drops data caches, and provides information about them. sp_cacheconfig [cachename [ ,"cache_size[P|K|M|G]" ] [,logonly | mixed ] [,strict | relaxed ] ] |
| sp_cachestrategy | sp_cachestrategy - Enables or disables prefetching (large I/O) and MRU cache replacement strategy for a table, index, text object, or image object. sp_cachestrategy dbname, [ownername.]tablename [, indexname | "text only" | "table only" [, { prefetch | mru }, { "on" | "off"}]] |
| sp_changedbowner | sp_changedbowner - Changes the owner of a user database. sp_changedbowner loginame [, true ] |
| sp_changegroup | sp_changegroup - Changes a user's group. sp_changegroup grpname, username |
| sp_checknames | sp_checknames - Checks the current database for names that contain characters not in the 7-bit ASCII set. sp_checknames |
| sp_checkreswords | sp_checkreswords - Detects and displays identifiers that are Transact-SQL reserved words. Checks server names, device names, database names, segment names, user-defined datatypes, object names, column names, user names, login names, and remote login names. sp_checkreswords [user_name_param] |
| sp_checksource | sp_checksource - Checks for the existence of the source text of the compiled object. sp_checksource [objname [, tabname [, username]]] |
| sp_chgattribute | space allocations of a table or an index. Sets the concurrency_opt_threshold for a table. concurrency_opt_threshold }, optvalue |
| sp_clearpsexe | sp_clearpsexe - Clears the execution attributes of an Adaptive Server session that was set by sp_setpsexe. sp_clearpsexe spid, exeattr |
| sp_clearstats | sp_clearstats - Initiates a new accounting period for all server users or for a specified user. Prints statistics for the previous period by executing sp_reportstats. sp_clearstats [loginame] |
| sp_column_privileges | sp_column_privileges - Returns permissions information for one or more columns in a table or view. sp_column_privileges table_name [, table_owner [, table_qualifier [, column_name]]] |
| sp_columns | sp_columns - Returns information about the type of data that can be stored in one or more columns. sp_columns table_name [, table_owner ] [, table_qualifier] [, column_name] |
| sp_commonkey | sp_commonkey - Defines a common key-columns that are frequently joined-between two tables or views. sp_commonkey tabaname, tabbname, col1a, col1b [, col2a, col2b, ..., col8a, col8b] |
| sp_configure | sp_configure - Displays or changes configuration parameters. sp_configure [configname [, configvalue] | group_name | non_unique_parameter_fragment] sp_configure "configuration file", 0, {"write" | "read" | "verify" | "restore"} "file_name" |
| sp_countmetadata | sp_countmetadata - Displays the number of indexes, objects, or databases in Adaptive Server. sp_countmetadata "configname" [, dbname] |
| sp_cursorinfo | sp_cursorinfo - Reports information about a specific cursor or all cursors that are active for your session. sp_cursorinfo [{cursor_level | null}] [, cursor_name] |
| sp_databases | sp_databases - Returns a list of databases in Adaptive Server. sp_databases |
| sp_datatype_info | sp_datatype_info - Returns information about a particular ODBC datatype or about all ODBC datatypes. sp_datatype_info [data_type] |
| sp_dboption | sp_dboption - Displays or changes database options. sp_dboption [dbname, optname, {true | false}] |
| sp_dbrecovery_order | sp_dbrecovery_order - Specifies the order in which individual user databases are recovered and lists the user-defined recovery order of an individual database or all databases. sp_dbrecovery_order [database_name [, rec_order [, force]]] |
| sp_dbremap | sp_dbremap - Forces Adaptive Server to recognize changes made by alter database. Run this procedure only when instructed to do so by an Adaptive Server message. sp_dbremap dbname |
| sp_defaultloc | sp_defaultloc - Defines a default storage location for objects in a local database. sp_defaultloc dbname, {"defaultloc"| NULL} [, "defaulttype"] |
| sp_depends | sp_depends - Displays information about database object dependencies-the view(s), trigger(s), and procedure(s) in the database that depend on a specified table or view, and the table(s) and view(s) in the database on which the specified view, trigger, or procedure depends. sp_depends objname |
| sp_diskdefault | sp_diskdefault - Specifies whether or not a database device can be used for database storage if the user does not specify a database device or specifies default with the create database or alter database commands. sp_diskdefault logicalname, {defaulton | defaultoff} |
| sp_displayaudit | sp_displayaudit - Displays the active audit options. sp_displayaudit [procedure | object | login | database | global | default_object | default_procedure [, "name"]] |
| sp_displaylevel | sp_displaylevel - Sets or shows which Adaptive Server configuration parameters appear in sp_configure output. sp_displaylevel [loginame [, level]] |
| sp_displaylogin | sp_displaylogin - Displays information about a login account. Also displays information about the hierarchy tree above or below the login account when you so specify. sp_displaylogin [loginame [, expand_up | expand_down]] |
| sp_displayroles | sp_displayroles - Displays all roles granted to another role, or displays the entire hierarchy tree of roles in table format. sp_displayroles {login_name | rolename [, expand_up | expand_down]} |
| sp_drop_resource_limit | sp_drop_resource_limit - Removes one or more resource limits from Adaptive Server. sp_drop_resource_limit {name, appname } [, rangename, limittype, enforced, action, scope] |
| sp_drop_time_range | sp_drop_time_range - Removes a user-defined time range from Adaptive Server. sp_drop_time_range name |
| sp_dropalias | sp_dropalias - Removes the alias user name identity established with sp_addalias. sp_dropalias loginame |
| sp_dropdevice | sp_dropdevice - Drops an Adaptive Server database device or dump device. sp_dropdevice logicalname |
| sp_dropengine | sp_dropengine - Drops an engine from a specified engine group or, if the engine is the last one in the group, drops the engine group. sp_dropengine engine_number, engine_group |
| sp_dropexeclass | sp_dropexeclass - Drops a user-defined execution class. sp_dropexeclass classname |
| sp_dropextendedproc | sp_dropextendedproc - Removes an extended stored procedure (ESP). sp_dropextendedproc esp_name |
| sp_dropexternlogin | sp_dropexternlogin - Drops the definition of a remote login previously defined by sp_addexternlogin. sp_dropexternlogin remote_server [, login_name] |
| sp_dropglockpromote | sp_dropglockpromote - Removes lock promotion values from a table or database. sp_dropglockpromote {"database" | "table"}, objname |
| sp_dropgroup | sp_dropgroup - Drops a group from a database. sp_dropgroup grpname |
| sp_dropkey | sp_dropkey - Removes from the syskeys table a key that had been defined using sp_primarykey, sp_foreignkey, or sp_commonkey. sp_dropkey keytype, tabname [, deptabname] |
| sp_droplanguage | sp_droplanguage - Drops an alternate language from the server and sp_droplanguage language [, dropmessages] |
| sp_droplogin | sp_droplogin - Drops an Adaptive Server user login by deleting the user's entry from master.dbo.syslogins. sp_droplogin loginame |
| sp_dropmessage | sp_dropmessage - Drops user-defined messages from sysusermessages. sp_dropmessage message_num [, language] |
| sp_dropobjectdef | sp_dropobjectdef - Deletes the external storage mapping provided for a local object. sp_dropobjectdef "object_name" |
| sp_dropremotelogin | sp_dropremotelogin - Drops a remote user login. sp_dropremotelogin remoteserver [, loginame [, remotename] ] |
| sp_droprowlockpromote | a database or table. |
| sp_dropsegment | sp_dropsegment - Drops a segment from a database or unmaps a segment from a particular database device. sp_dropsegment segname, dbname [, device] |
| sp_dropserver | sp_dropserver - Drops a server from the list of known servers or drops remote logins and external logins in the same operation. sp_dropserver server [, droplogins] |
| sp_dropthreshold | sp_dropthreshold - Removes a free-space threshold from a segment. sp_dropthreshold dbname, segname, free_space |
| sp_droptype | sp_droptype - Drops a user-defined datatype. sp_droptype typename |
| sp_dropuser | sp_dropuser - Drops a user from the current database. sp_dropuser name_in_db |
| sp_estspace | sp_estspace - Estimates the amount of space required for a table and its indexes, and the time needed to create the index. [, cols_to_max [, textbin_len [, iosec]]]] |
| sp_extendsegment | sp_extendsegment - Extends the range of a segment to another database device. sp_extendsegment segname, dbname, devname |
| sp_familylock | sp_familylock - Reports information about all the locks held by a family (coordinating process and its worker processes) executing a statement in parallel. sp_familylock [fpid1 [, fpid2]] |
| sp_fkeys | sp_fkeys - Returns information about foreign key constraints created with the create table or alter table command in the current database. sp_fkeys pktable_name [, pktable_owner] [, pktable_qualifier] [, fktable_name] [, fktable_owner] [, fktable_qualifier] |
| sp_flushstats | sp_flushstats - Flushes statistics from in-memory storage to the systabstats system table. sp_flushstats objname |
| sp_forceonline_db | sp_forceonline_db - Provides access to all the pages in a database that were previously marked suspect by recovery. sp_forceonline_page dbname, {"sa_on" | "sa_off" | "all_users"} |
| sp_forceonline_object | sp_forceonline_object - Provides access to an index previously marked suspect by recovery. sp_forceonline_object dbname, objname, indid, {sa_on | sa_off | all_users} [, no_print] |
| sp_forceonline_page | sp_forceonline_page - Provides access to pages previously marked suspect by recovery. sp_forceonline_page dbname, pgid, {"sa_on" | "sa_off" | "all_users"} |
| sp_foreignkey | sp_foreignkey - Defines a foreign key on a table or view in the current database. sp_foreignkey tabname, pktabname, col1 [, col2] ... [, col8] |
| sp_freedll | sp_freedll - Unloads a dynamic link library (DLL) that was previously loaded into XP Server memory to support the execution of an extended stored procedure (ESP). sp_freedll dll_name |
| sp_getmessage | sp_getmessage - Retrieves stored message strings from sysmessages and sysusermessages for print and raiserror statements. sp_getmessage message_num, result output [, language] |
| sp_grantlogin | sp_grantlogin - Assigns Adaptive Server roles or default permissions to Windows NT users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active. sp_grantlogin {login_name | group_name} ["role_list" | default] |
| sp_help | for tables. sp_help table_name |
| sp_help_resource_limit | sp_help_resource_limit - Reports on resource limits. sp_help_resource_limit [name [, appname [, limittime [, limitday [, scope [, action]]]]]] |
| sp_helpartition | sp_helpartition - Lists the partition number, first page, control page, and number of data pages and summary size information for each partition in a partitioned table. sp_helpartition [table_name] |
| sp_helpcache | sp_helpcache - Displays information about the objects that are bound to a data cache or the amount of overhead required for a specified cache size. sp_helpcache {cache_name | "cache_size[P|K|M|G]"} |
| sp_helpconfig | sp_helpconfig - Reports help information on configuration parameters. sp_helpconfig "configname", ["size"] |
| sp_helpconstraint | sp_helpconstraint - Reports information about integrity constraints used in the specified tables. sp_helpconstraint [objname] [, detail] |
| sp_helpdb | database. sp_helpdb [dbname] |
| sp_helpdevice | sp_helpdevice - Reports information about a particular device or about all Adaptive Server database devices and dump devices. sp_helpdevice [devname] |
| sp_helpextendedproc | sp_helpextendedproc - Displays extended stored procedures (ESPs) in the current database, along with their associated DLL files. sp_helpextendedproc [esp_name] |
| sp_helpexternlogin | sp_helpexternlogin - Reports information about external login names. sp_helpexternlogin [remote_server [, login_name]] |
| sp_helpgroup | sp_helpgroup - Reports information about a particular group or about all groups in the current database. sp_helpgroup [grpname] |
| sp_helpindex | sp_helpindex - Reports new information about the indexes created on a table. sp_helpindex objname |
| sp_helpjoins | sp_helpjoins - Lists the columns in two tables or views that are likely join candidates. sp_helpjoins lefttab, righttab |
| sp_helpkey | sp_helpkey - Reports information about a primary, foreign, or common key of a particular table or view, or about all keys in the current database. sp_helpkey [tabname] |
| sp_helplanguage | sp_helplanguage - Reports information about a particular alternate language or about all languages. sp_helplanguage [language] |
| sp_helplog | sp_helplog - Reports the name of the device that contains the first page of the transaction log. sp_helplog |
| sp_helpobjectdef | sp_helpobjectdef - Reports owners, objects, and type information for remote object definitions. sp_helpobjectdef [object_name] |
| sp_helpremotelogin | sp_helpremotelogin - Reports information about a particular remote server's logins or about all remote server logins. sp_helpremotelogin [remoteserver [, remotename]] |
| sp_helprotect | sp_helprotect - Reports on permissions for database objects, users, groups, or roles. sp_helprotect [name [, username [, "grant" [,"none"|"granted"|"enabled"|role_name]]]] |
| sp_helpsegment | sp_helpsegment - Reports information about a particular segment or about all segments in the current database. sp_helpsegment [segname] |
| sp_helpserver | sp_helpserver - Reports information about a particular remote server or about all remote servers. sp_helpserver [server] |
| sp_helpsort | sp_helpsort - Displays Adaptive Server's default sort order and character set. sp_helpsort |
| sp_helptext | sp_helptext - Displays the source text of a compiled object. sp_helptext objname |
| sp_helpthreshold | sp_helpthreshold - Reports the segment, free-space value, status, and stored procedure associated with all thresholds in the current database or all thresholds for a particular segment. sp_helpthreshold [segname] |
| sp_helpuser | sp_helpuser - Reports information about a particular user, group, or alias, or about all users, in the current database. sp_helpuser [name_in_db] |
| sp_hidetext | sp_hidetext - Hides the source text for the specified compiled object. sp_hidetext [objname [, tabname [, username]]] |
| sp_indsuspect | sp_indsuspect - Checks user tables for indexes marked as suspect during recovery following a sort order change. sp_indsuspect [tab_name] |
| sp_listsuspect_db | sp_listsuspect_db - Lists all databases that currently have offline pages because of corruption detected on recovery. sp_listsuspect_db |
| sp_listsuspect_object | sp_listsuspect_object - Lists all indexes in a database that are currently offline because of corruption detected on recovery. sp_listsuspect_object [dbname] |
| sp_listsuspect_page | sp_listsuspect_page - Lists all pages in a database that are currently offline because of corruption detected on recovery. sp_listsuspect_page [dbname] |
| sp_lock | sp_lock - Reports additional information about processes that currently hold locks. sp_lock [spid1 [, spid2]] |
| sp_locklogin | sp_locklogin - Locks an Adaptive Server account so that the user cannot log in or displays a list of all locked accounts. sp_locklogin [loginame, "{lock | unlock}"] |
| sp_logdevice | sp_logdevice - Moves the transaction log of a database with log and data on the same device to a separate database device. sp_logdevice dbname, devname |
| sp_loginconfig | sp_loginconfig - Displays the value of one or all integrated security parameters. sp_loginconfig ["parameter_name"] |
| sp_logininfo | sp_logininfo - Displays all roles granted to Windows NT users and groups with sp_grantlogin. sp_logininfo ["login_name" | "group_name"] |
| sp_logiosize | sp_logiosize - Changes the log I/O size used by Adaptive Server to a different memory pool when doing I/O for the transaction log of the current database. sp_logiosize ["default" | "size" | "all"] |
| sp_modify_resource_limit | sp_modify_resource_limit - Changes a resource limit by specifying a new limit value or the action to take when the limit is exceeded, or both. sp_modify_resource_limit {name, appname } , rangename, limittype [, limitvalue] [, enforced] [, action] [, scope] |
| sp_modify_time_range | sp_modify_time_range - Changes the start day, start time, end day, and/or end time associated with a named time range. sp_modify_time_range name, startday, endday, starttime, endtime |
| sp_modifylogin | sp_modifylogin - Modifies the default database, default language, default role activation, or full name for a Adaptive Server login account. sp_modifylogin account, column, value |
| sp_modifythreshold | sp_modifythreshold - Modifies a threshold by associating it with a different threshold procedure, free-space level, or segment name. You cannot use sp_modifythreshold to change the amount of free space or the segment name for the last-chance threshold. sp_modifythreshold dbname, segname, free_space [, new_proc_name] [, new_free_space] [, new_segname] |
| sp_monitor | sp_monitor - Displays statistics about Adaptive Server. sp_monitor |
| sp_monitorconfig | sp_monitorconfig - Displays cache usage statistics regarding metadata descriptors for indexes, objects, and databases. sp_monitorconfig also reports statistics on auxiliary scan descriptors used for referential integrity queries. sp_monitorconfig "configname" |
| sp_object_stats | sp_object_stats - Prints lock statistics for tables and indexes. sp_object_stats interval [, top_n [, dbname, objname [, rpt_option ]]] |
| sp_passthru | sp_passthru - Allows the user to pass a SQL command buffer to a remote server. [, arg1, arg2, ... argn] |
| sp_password | sp_password - Adds or changes a password for an Adaptive Server login account. sp_password caller_passwd, new_passwd [, loginame] |
| sp_pkeys | sp_pkeys - Returns information about primary key constraints created with the create table or alter table command for a single table. sp_pkeys table_name [, table_owner] [, table_qualifier] |
| sp_placeobject | sp_placeobject - Puts future space allocations for a table or index on a particular segment. sp_placeobject segname, objname |
| sp_plan_dbccdb | sp_plan_dbccdb - Recommends suitable sizes for new dbccdb and dbccalt databases, lists suitable devices for dbccdb and dbccalt, and suggests a cache size and a suitable number of worker processes for the target database. sp_plan_dbccdb [dbname] |
| sp_poolconfig | sp_poolconfig - Creates, drops, resizes, and provides information about memory pools within data caches. To create a memory pool in an existing cache, or to change pool size: sp_poolconfig cache_name [, "mem_size[P|K|M|G]", "config_poolK" [, "affected_poolK"]] To change a pool's wash size: sp_poolconfig cache_name, "io_size", "wash=size[P|K|M|G]" To change a pool's asynchronous prefetch percentage: sp_poolconfig cache_name, "io_size", "local async prefetch limit=percent" |
| sp_primarykey | sp_primarykey - Defines a primary key on a table or view. sp_primarykey tabname, col1 [, col2, col3, ..., col8] |
| sp_processmail | sp_processmail - Reads, processes, sends, and deletes messages in the Adaptive Server message inbox, using the xp_findnextmsg, xp_readmail, xp_sendmail, and xp_deletemail system extended stired procedures (ESPs). sp_processmail [subject] [, originator [, dbuser [, dbname [, filetype [, separator]]]]] |
| sp_procqmode | sp_procqmode - Displays the query processing mode of a stored procedure, view, or trigger. sp_procqmode [object_name [, detail]] |
| sp_procxmode | sp_procxmode - Displays or changes the transaction modes associated with stored procedures. sp_procxmode [procname [, tranmode]] |
| sp_recompile | sp_recompile - Causes each stored procedure and trigger that uses the named table to be recompiled the next time it runs. sp_recompile objname |
| sp_remap | sp_remap - Remaps a stored procedure, trigger, rule, default, or view from releases later than 4.8 and prior to 10.0 to be compatible with releases 10.0 and later. Use sp_remap on pre-existing objects that the upgrade procedure failed to remap. sp_remap objname |
| sp_remoteoption | sp_remoteoption - Displays or changes remote login options. sp_remoteoption [remoteserver [, loginame [, remotename [, optname [, optvalue]]]]] |
| sp_remotesql | sp_remotesql - Establishes a connection to a remote server, passes a query buffer to the remote server from the client, and relays the results back to the client. sp_remotesql server, query [, query2, ... , query254] |
| sp_rename | sp_rename - Changes the name of a user-created object or user-defined datatype in the current database. sp_rename objname, newname |
| sp_renamedb | sp_renamedb - Changes the name of a user database. sp_renamedb dbname, newname |
| sp_reportstats | sp_reportstats - Reports statistics on system usage. sp_reportstats [loginame] |
| sp_revokelogin | sp_revokelogin - Revokes Adaptive Server roles and default permissions from Windows NT users and groups when Integrated Security mode or Mixed mode (with Named Pipes) is active. sp_revokelogin {login_name | group_name} |
| sp_role | sp_role - Grants or revokes system roles to an Adaptive Server login account. sp_role {"grant" | "revoke"}, {sa_role | sso_role | oper_role}, loginame |
| sp_server_info | sp_server_info - Returns a list of Adaptive Server attribute names and current values. sp_server_info [attribute_id] |
| sp_serveroption | sp_serveroption - Displays or changes remote server options. sp_serveroption [server, optname, optvalue] |
| sp_setlangalias | sp_setlangalias - Assigns or changes the alias for an alternate language. sp_setlangalias language, alias |
| sp_setpglockpromote | sp_setpglockpromote - Sets or changes the lock promotion thresholds for a database, for a table, or for Adaptive Server. sp_setpglockpromote {"database" | "table"}, objname, new_lwm, new_hwm, new_pct sp_setpglockpromote server, NULL, new_lwm, new_hwm, new_pct |
| sp_setpsexe | sp_setpsexe - Sets custom execution attributes "on the fly" for a session. sp_setpsexe spid, exeattr, value |
| sp_setrowlockpromote | tables on a server. new_hwm, new_pct new_lwm, new_hwm, new_pct |
| sp_setsuspect_granularity | sp_setsuspect_granularity - Displays or sets the recovery fault isolation mode for a user database, which governs how recovery behaves when it detects data corruption. sp_setsuspect_granularity [dbname [,{"database" | "page"} [, "read_only"]]] |
| sp_setsuspect_threshold | sp_setsuspect_threshold - Displays or sets the maximum number of suspect pages that Adaptive Server allows in a database before marking the entire database suspect. sp_setsuspect_threshold [dbname [, threshold]] |
| sp_showcontrolinfo | sp_showcontrolinfo - Displays information about engine group assignments, bound client applications, logins, and stored procedures. sp_showcontrolinfo [object_type, object_name, spid] |
| sp_showexeclass | sp_showexeclass - Displays the execution class attributes and the engines in any engine group associated with the specified execution class. sp_showexeclass [execlassname] |
| sp_showplan | sp_showplan - Displays the showplan output for any user connection for the current SQL statement or for a previous statement in the same batch. sp_showplan spid, batch_id output, context_id output, stmt_num output To display the showplan output for the current SQL statement without specifying the batch_id, context_id, or stmt_num: sp_showplan spid, null, null, null |
| sp_showpsexe | sp_showpsexe - Displays execution class, current priority, and affinity for all client sessions running on Adaptive Server. sp_showpsexe [spid] |
| sp_spaceused | number of data pages, the size of indexes, and the space used by a specified table or by all tables in the current database. sp_spaceused [objname [,1] ] |
| sp_special_columns | sp_special_columns - Returns the optimal set of columns that uniquely return a list of timestamp columns, whose values are automatically generated when any value in the sp_special_columns table_name [, table_owner] [, table_qualifier] [, col_type] |
| sp_sproc_columns | sp_sproc_columns - Returns information about a stored procedure's input and return parameters. sp_sproc_columns procedure_name [, procedure_owner] [, procedure_qualifier] [, column_name] |
| sp_statistics | sp_statistics - Returns a list of indexes on a single table. sp_statistics table_name [, table_owner] [, table_qualifier] [, index_name] [, is_unique] |
| sp_stored_procedures | sp_stored_procedures - Returns information about one or more stored procedures. sp_stored_procedures [sp_name [, sp_owner [, sp_qualifier]]] |
| sp_syntax | system procedures, utilities, and other routines for Adaptive Server, depending on which products and corresponding sp_syntax scripts exist on your server. sp_syntax word [, mod][, language] |
| sp_sysmon | sp_sysmon - Displays performance information. sp_sysmon { begin_sample | end_sample | interval } [, section] |
| sp_table_privileges | sp_table_privileges - Returns privilege information for all columns in a table or view. sp_table_privileges table_name [, table_owner [, table_qualifier]] |
| sp_tables | sp_tables - Returns a list of objects that can appear in a from clause. sp_tables [table_name] [, table_owner] [, table_qualifier][, table_type] |
| sp_thresholdaction | sp_thresholdaction - Executes automatically when the number of free pages on the log segment falls below the last-chance threshold, unless the threshold is associated with a different procedure. Sybase does not provide this procedure. When a threshold is crossed, Adaptive Server passes the following parameters to the threshold procedure by position: sp_thresholdaction @dbname, @segment_name, @space_left, @status |
| sp_unbindcache | sp_unbindcache - Unbinds a database, table, index, text object, or image object from a data cache. sp_unbindcache dbname [,[owner.]tablename [, indexname | "text only"]] |
| sp_unbindcache_all | sp_unbindcache_all - Unbinds all objects that are bound to a cache. sp_unbindcache_all cache_name |
| sp_unbindefault | sp_unbindefault - Unbinds a created default value from a column or from a user-defined datatype. sp_unbindefault objname [, futureonly] |
| sp_unbindexeclass | sp_unbindexeclass - Removes the execution class attribute previously associated with an client application, login, or stored procedure for the specified scope. sp_unbindexeclass object_name, object_type, scope |
| sp_unbindmsg | sp_unbindmsg - Unbinds a user-defined message from a constraint. sp_unbindmsg constrname |
| sp_unbindrule | sp_unbindrule - Unbinds a rule from a column or from a user-defined datatype. sp_unbindrule objname [, futureonly] |
| sp_volchanged | sp_volchanged - Notifies the Backup Server that the operator performed the requested volume handling during a dump or load. sp_volchanged session_id, devname, action [, fname [, vname]] |
| sp_who | sp_who - Reports information about all current Adaptive Server users and processes or about a particular user or process. sp_who [loginame | "spid"] |