Sql Server 2005 Db Engine Stored Procedures

Front 1

Create and store a user defined message inside the instance

Back 1

sp_addmessage

Front 2

Create a backup device

Back 2

sp_addumpdevice

Front 3

Alter a user defined message inside the instance

Back 3

sp_altermessage

Front 4

Attache a database file to the instance

Back 4

sp_attach_db

Front 5

Attach a database file when no associated log file is avaialbe

Back 5

sp_attach_single_file_db

Front 6

Display or alter the UPDATE STATISTICS setting for a table

Back 6

sp_autostats

Front 7

Display or alter instance configuration settings for instance

Back 7

sp_configure

Front 8

sp_configure 'options'

Back 8

allow updates
backup compression default
clr enabled
cross db ownership chaining
default language
filestream access level
max text repl size (B)
nested triggers
remote access
remote admin connections
remote login timeout (s)
remote proc trans
remote query timeout (s)
server trigger recursion
show advanced options
user options

Front 9

sp_configure after 'show advanced options', 1

Back 9

access check cache bucket count
access check cache quota
Ad Hoc Distributed Queries
affinity I/O mask
affinity mask
Agent XPs
allow updates
awe enabled
backup compression default
blocked process threshold (s)
c2 audit mode
clr enabled
common criteria compliance enabled
cost threshold for parallelism
cross db ownership chaining
cursor threshold
Database Mail XPs
default full-text language
default language
default trace enabled
disallow results from triggers
EKM provider enabled
filestream access level
fill factor (%)
ft crawl bandwidth (max)
ft crawl bandwidth (min)
ft notify bandwidth (max)
ft notify bandwidth (min)
index create memory (KB)
in-doubt xact resolution
lightweight pooling
locks
max degree of parallelism
max full-text crawl range
max server memory (MB)
max text repl size (B)
max worker threads
media retention
min memory per query (KB)
min server memory (MB)
nested triggers
network packet size (B)
Ole Automation Procedures
open objects
optimize for ad hoc workloads
PH timeout (s)
precompute rank
priority boost
query governor cost limit
query wait (s)
recovery interval (min)
remote access
remote admin connections
remote login timeout (s)
remote proc trans
remote query timeout (s)
Replication XPs
scan for startup procs
server trigger recursion
set working set size
show advanced options
SMO and DMO XPs
SQL Mail XPs
transform noise words
two digit year cutoff
user connections
user options
xp_cmdshell

Front 10

Create statistics for columns in a table

Back 10

sp_createstats

Front 11

Cycle the error log as if the server had been restarted

Back 11

sp_cycle_errorlog

Front 12

Display List of supported data types

Back 12

sp_datatype_info

Front 13

Alters database behaviors to be compatible with previous versions

Back 13

sp_dbcmptlevel

Front 14

Display or alter configuration settings for a database

Back 14

sp_dboption

Front 15

Remove a database and all associated database file

Back 15

sp_dbremove
(backwards compatiability only)

Front 16

Delete backups and restore entries in msdb older than specfied date

Back 16

sp_delete_backuphistory

Front 17

Display dependency information about the specified object

Back 17

sp_depends 'object'

Front 18

Detach a database

Back 18

sp_detach_db

Front 19

Delete a device from the instance

Back 19

sp_dropdevice

Front 20

Remove a user defined message from the instance

Back 20

sp_dropmessage

Front 21

Execute a T-SQL statment

Back 21

sp_executesql @stmt

Front 22

Return info about specified database object

Back 22

sp_help

Front 23

Retun info about a specified database

Back 23

sp_helpdb

Front 24

Return info about backup device

Back 24

sp_help_device @devname

Front 25

Return name of DLL for extended stored procedure

Back 25

sp_helpextendedproc

Front 26

Return information on specified database files or all db files

Back 26

sp_helpfile

Front 27

Return info on filegroup

Back 27

sp_helpfilegroup

Front 28

Return index information

Back 28

sp_helpindex @objectname

Front 29

Return info on remote, linked or replicated servers

Back 29

sp_helpserver

Front 30

Return sort order

Back 30

sp_helpsort

Front 31

Return statistic information on specified table

Back 31

sp_helpstats

Front 32

return the definition of object

Back 32

sp_helptext

Front 33

return information on DML triggers

Back 33

sp_helptrigger @tablename

Front 34

Confiure locking options for specified table or index

Back 34

sp_indexoption

Front 35

Return information about locks

Back 35

sp_lock

Front 36

Get stats for instance

Back 36

sp_monitor

Front 37

Configure the specified stored procedure to be executed when the server instance is started

Back 37

sp_procoption

Front 38

Configure a procedure or trigger to be recompiled upon next execution

Back 38

sp_recompile

Front 39

Refresh metadata for a view

Back 39

sp_refreshview @viewname

Front 40

Alter the name of a specified object

Back 40

sp_rename

Front 41

Alter name of a database

Back 41

sp_renamedb

Front 42

configure teh AFTER triggers to be fired either first or last

Back 42

sp_settriggerorder

Front 43

Return space information for the specified object or current database

Back 43

sp_spaceused

Front 44

Configure option for specified table

Back 44

sp_tableoption

Front 45

Update statistics for all tables in database

Back 45

sp_updatestats

Front 46

Return information about the specified login or all logins currently connected to the instance

Back 46

sp_who