Reserved words etc.

Is there a comprehensive list of SQL reserved words and other keywords that
includes abbreviations (eg EXEC, TRAN etc.), functions, catalog view object
names (eg object_id, sys.tables) etc? BOL seems to have a limited set. I'm
thinking of anything that the code editor might flag with a color.
tx
s
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp
"s" <a@.b.com> wrote in message news:ekvYsk2FHHA.3540@.TK2MSFTNGP02.phx.gbl...
> Is there a comprehensive list of SQL reserved words and other keywords
> that includes abbreviations (eg EXEC, TRAN etc.), functions, catalog view
> object names (eg object_id, sys.tables) etc? BOL seems to have a limited
> set. I'm thinking of anything that the code editor might flag with a
> color.
> tx
>
|||thanks but that is a short list and, although it includes EXEC and TRAN, it
doesn't include many other keywords
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%231ruA92FHHA.4844@.TK2MSFTNGP03.phx.gbl...
> s
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_9oj7.asp
>
>
> "s" <a@.b.com> wrote in message
> news:ekvYsk2FHHA.3540@.TK2MSFTNGP02.phx.gbl...
>
|||s wrote:
> Is there a comprehensive list of SQL reserved words and other keywords that
> includes abbreviations (eg EXEC, TRAN etc.), functions, catalog view object
> names (eg object_id, sys.tables) etc? BOL seems to have a limited set. I'm
> thinking of anything that the code editor might flag with a color.
> tx
>
This is the list of words that are "colored" from a syntax highlighter
plugin that I use on my website:
ABSOLUTE
ACTION
ALLOCATE
ARE
ASSERTION
AT
AUTHORIZATION
BOTH
CASCADE
CASCADED
CAST
CATALOG
CHAR_LENGTH
CHARACTER
CHARACTER_LENGTH
COLLATE
COLLATION
COLUMN
CONNECT
CONNECTION
CONSTRAINTS
CORRESPONDING
DATE
DAY
DEFERRABLE
DEFERRED
DESCRIBE
DESCRIPTOR
DIAGNOSTICS
DISCONNECT
DOMAIN
END_EXEC
ESCAPE
EXCEPTION
EXPIREDATE
EXTERNAL
EXTRACT
FALSE
FILE
FIRST
FULL
GET
GLOBAL
HOUR
IMMEDIATE
INITIALLY
INNER
INPUT
INTERVAL
JOIN
LAST
LEADING
LEFT
LOCAL
MATCH
MINUTE
MONTH
NAMES
NATIONAL
NATURAL
NCHAR
NEXT
NO
OCTET_LENGTH
OUTER
OUTPUT
OVERLAPS
PAD
PARTIAL
POSITION
PRESERVE
PRIOR
PRIVILEGES
RELATIVE
RESTRICT
RETAINDAYS
RIGHT
ROWS
SCHEMA
SECOND
SESSION
SIZE
SPACE
SQLSTATE
TIME
TIMEZONE_HOUR
TIMEZONE_MINUTE
TRAILING
TRANSLATE
TRANSLATION
TRUE
UNKNOWN
USAGE
USING
VALUE
VOLUME
WORK
WRITE
YEAR
ZONE
ADD
ALL
ALTER
AND
ANY
AS
ASC
AVG
BEGIN
BETWEEN
BREAK
BROWSE
BULK
BY
CASE
CHECK
CHECKPOINT
CLOSE
CLUSTERED
COALESCE
COMMIT
COMMITTED
COMPUTE
CONFIRM
CONSTRAINT
CONTINUE
CONTROLROW
CONVERT
COUNT
CREATE
CURRENT
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
DATABASE
DBCC
DEALLOCATE
DECLARE
DEFAULT
DELETE
DESC
DISK
DISTINCT
DOUBLE
DROP
DUMMY
DUMP
ELSE
END
ERRLVL
ERROREXIT
EXCEPT
EXEC
EXECUTE
EXISTS
EXIT
FETCH
FILLFACTOR
FLOPPY
FOR
FOREIGN
FROM
GOTO
GRANT
GROUP
HAVING
HOLDLOCK
IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IF
IN
INDEX
INSENSITIVE
INSERT
INTERSECT
INTO
IS
ISOLATION
KEY
KILL
LEVEL
LIKE
LINENO
LOAD
MAX
MIN
MIRROREXIT
NOCHECK
NONCLUSTERED
NOT
NULL
NULLIF
OF
OFF
OFFSETS
ON
ONCE
ONLY
OPEN
OPTION
OR
ORDER
OVER
PERM
PERMANENT
PIPE
PLAN
PRECISION
PREPARE
PRIMARY
PRINT
PROC
PROCEDURE
PROCESSEXIT
PUBLIC
RAISERROR
READ
RECONFIGURE
REFERENCES
REPEATABLE
REPLICATION
RETURN
REVOKE
ROLLBACK
ROWCOUNT
RULE
SAVE
SCROLL
SELECT
SERIALIZABLE
SESSION_USER
SET
SETUSER
SHUTDOWN
SOME
STATISTICS
SUM
SYSTEM_USER
TABLE
TAPE
TEMP
TEMPORARY
TEXTSIZE
THEN
TO
TRAN
TRANSACTION
TRIGGER
TRUNCATE
TSEQUAL
UNCOMMITTED
UNION
UNIQUE
UPDATE
UPDATETEXT
USE
USER
VALUES
VARYING
VIEW
WAITFOR
WHEN
WHERE
WHILE
WITH
WRITETEXT
sp_column_privileges
sp_special_columns
sp_columns
sp_sproc_columns
sp_databases
sp_statistics
sp_datatype_info
sp_stored_procedures
sp_fkeys
sp_table_privileges
sp_pkeys
sp_tables
sp_server_info
sp_addpublisher
sp_dropsubscriber
sp_addsubscriber
sp_helpdistributor
sp_changesubscriber
sp_helpserver
sp_dboption
sp_helpsubscriberinfo
sp_droppublisher
sp_replsync
sp_addarticle
sp_helparticle
sp_addpublication
sp_helparticlecolumns
sp_articlecolumn
sp_helppublication
sp_changearticle
sp_helppublicationsync
sp_changepublication
sp_helpreplicationdb
sp_droparticle
sp_replflush
sp_droppublication
sp_replstatus
sp_enumfullsubscribers
sp_addsubscription
sp_helpsubscription
sp_changesubscription
sp_subscribe
sp_changesubstatus
sp_unsubscribe
sp_dropsubscription
sp_distcounters
sp_replica
sp_replcleanup
sp_MSkill_job
sp_repldone
sp_replcmds
sp_repltrans
sp_replcounters
sp_addtask
sp_helptask
sp_droptask
sp_addalert
sp_helpalert
sp_addnotification
sp_helpnotification
sp_addoperator
sp_helpoperator
sp_dropalert
sp_updatealert
sp_dropnotification
sp_updatenotification
sp_dropoperator
sp_updateoperator
sp_purgehistory
sp_helphistory
sp_updatetask
sp_MSSQLOLE65_version
sp_MSSQLOLE_version
sp_MS_upd_sysobj_category
sp_MSdbuserprofile
sp_MSdependencies
sp_MSenumsubsystems
sp_MSfilterclause
sp_MSforeach_worker
sp_MSforeachdb
sp_MSforeachtable
sp_MSgetalertinfo
sp_MSgetexecinfo
sp_MShelpcolumns
sp_MShelpindex
sp_MShelptype
sp_MSindexspace
sp_MSkilldb
sp_MSloginmappings
sp_MSmatchkey
sp_MSobjectprivs
sp_MSsetalertinfo
sp_MSsetexecinfo
sp_MSsettopology
sp_MSsubscriptions
sp_MStablechecks
sp_MStablekeys
sp_MStablerefs
sp_MStablespace
sp_MSuninstall_publishing
sp_MSuniquename
sp_TDGEN_CURSOR1
sp_TD_table_summary
sp_TDaccess_server_drives
sp_TDblocks
sp_TDcheck_indexes
sp_TDcheck_rowcount
sp_TDdb_locks
sp_TDdbsizes_data
sp_TDdbsizes_log
sp_TDdbsizes_total
sp_TDdefault_db_audit
sp_TDdevspace
sp_TDdroplogin
sp_TDformat_commas
sp_TDget_logins
sp_TDgetdbsizes
sp_TDhelpdb
sp_TDhelplogin
sp_TDmirrorlogin
sp_TDpassword_change
sp_TDrunthis
sp_TDspaceused
sp_TDtable_sizes
sp_TDupdate_stats
sp_a_count_bits_on
sp_abort_xact
sp_add_app_user
sp_addalias
sp_addextendedproc
sp_addgroup
sp_addlanguage
sp_addlogin
sp_addmessage
sp_addremotelogin
sp_addsegment
sp_addserver
sp_addtype
sp_addumpdevice
sp_adduser
sp_altermessage
sp_articlefilter
sp_articletextcol
sp_articleview
sp_bindefault
sp_bindrule
sp_blockcnt
sp_certify_removable
sp_change_users_login
sp_changedbowner
sp_changegroup
sp_check_objects
sp_check_removable
sp_checknames
sp_chklangparam
sp_coalesce_fragments
sp_commit_xact
sp_commonkey
sp_configure
sp_create_distribution_tables
sp_create_removable
sp_db_locks
sp_db_upgrade
sp_db_upgrade1
sp_db_upgrade2
sp_db_upgrade3
sp_dbinstall
sp_dbremove
sp_ddopen
sp_defaultdb
sp_defaultlanguage
sp_depends
sp_devcreate
sp_devoption
sp_diskdefault
sp_dropalias
sp_dropdevice
sp_dropextendedproc
sp_dropgroup
sp_dropkey
sp_droplanguage
sp_droplogin
sp_dropmessage
sp_dropremotelogin
sp_dropsegment
sp_dropserver
sp_droptype
sp_dropuser
sp_dropwebtask
sp_dsninfo
sp_dtdba_checkfull
sp_dtdba_constraint
sp_dtdba_createsql
sp_dtdba_freedevice
sp_dtdba_getobj
sp_dtdba_getobjectpermissions
sp_dtdba_gettabkey
sp_dtdba_gettabper
sp_dtdba_getuserpermissions
sp_dtdba_helpcolumn
sp_dtdba_helpcolumn2
sp_dtdba_indexkeys
sp_dtdba_userprotects
sp_enumdsn
sp_exec
sp_extendsegment
sp_fallback_MS_enroll_db
sp_fallback_MS_enroll_dev
sp_fallback_MS_enroll_usg
sp_fallback_MS_sel_fb_svr
sp_fallback_MS_verify_ri
sp_fallback_activate_svr
sp_fallback_deactivate_svr
sp_fallback_deactivate_svr_db
sp_fallback_enroll_svr_db
sp_fallback_help
sp_fallback_help_db_dev
sp_fallback_permanent_svr
sp_fallback_upd_dev_drive
sp_fallback_withdraw_svr_db
sp_fixindex
sp_foreignkey
sp_get_volume_label
sp_hcchangesubstatus1
sp_hcchangesubstatus2
sp_help
sp_help_revdatabase
sp_helpconstraint
sp_helpdb
sp_helpdevice
sp_helpextendedproc
sp_helpgroup
sp_helpindex
sp_helpjoins
sp_helpkey
sp_helplanguage
sp_helplog
sp_helplogins
sp_helpremotelogin
sp_helprotect
sp_helpsegment
sp_helpsort
sp_helpsql
sp_helpstartup
sp_helptext
sp_helpuser
sp_kill
sp_lock
sp_lock2
sp_lockinfo
sp_logdevice
sp_lookup
sp_makestartup
sp_makewebtask
sp_markreport
sp_monitor
sp_namecrack
sp_namecrack_qi
sp_objcheck
sp_objectsegment
sp_password
sp_placeobject
sp_primarykey
sp_probe_xact
sp_processinfo
sp_processmail
sp_publishdb
sp_recompile
sp_remoteoption
sp_remove_xact
sp_rename
sp_renamedb
sp_runwebtask
sp_scan_xact
sp_schedulersignal
sp_serveroption
sp_setlangalias
sp_setnetname
sp_spaceused
sp_sqlexec
sp_sqlregister
sp_start_xact
sp_stat_xact
sp_sysbackuphistory_limiter
sp_tableoption
sp_tempdbspace
sp_textcolstatus
sp_unbindefault
sp_unbindrule
sp_unmakestartup
sp_user_counter1
sp_user_counter10
sp_user_counter2
sp_user_counter3
sp_user_counter4
sp_user_counter5
sp_user_counter6
sp_user_counter7
sp_user_counter8
sp_user_counter9
sp_userdefcounters
sp_validlang
sp_validname
sp_who
sp_who2
xp_enumgroups
xp_logininfo
xp_grantlogin
xp_revokelogin
xp_loginconfig
xp_deletemail
xp_sendmail
xp_findnextmsg
xp_startmail
xp_readmail
xp_stopmail
xp_cmdshell
xp_sprintf
xp_logevent
xp_sscanf
xp_msver
CONNECTIONS
CPU_BUSY
CURSOR_ROWS
DATEFIRST
DBTS
ERROR
FETCH_STATUS
IDLE
IO_BUSY
LANGID
LANGUAGE
MAX_CONNECTIONS
MAX_PRECISION
MICROSOFTVERSION
NESTLEVEL
PACK_RECEIVED
PACK_SENT
PACKET_ERRORS
PROCID
REMSERVER
SERVERNAME
SERVICENAME
SPID
TIMETICKS
TOTAL_ERRORS
TOTAL_READ
TOTAL_WRITE
TRANCOUNT
VERSION
ABS
ACOS
ASCII
ASIN
ATAN
ATN2
COL_NAME
CHARINDEX
CHAR
COT
COS
CEILING
COL_LENGTH
DB_NAME
DB_ID
DATALENGTH
DIFFERENCE
DATEADD
DATENAME
DATEDIFF
DATEPART
DEGREES
EXP
FLOOR
GETANSINULL
GETDATE
HOST_ID
HOST_NAME
ISNULL
INDEX_COL
IDENT_SEED
IDENT_INCR
LOWER
LTRIM
LOG
LOG10
OBJECT_ID
OBJECT_NAME
PATINDEX
POWER
PI
RTRIM
REVERSE
REPLICATE
RADIANS
RAND
ROUND
SUSER_NAME
SUSER_ID
STATS_DATE
SUBSTRING
STUFF
STR
SOUNDEX
SIGN
SIN
SQRT
TEXTVALID
TEXTPTR
TAN
USER_NAME
USER_ID
UPPER
BINARY
BIT
DATETIME
DECIMAL
FLOAT
IMAGE
INT
MONEY
NTEXT
NUMERIC
NVARCHAR
REAL
SMALLDATETIME
SMALLMONEY
TEXT
TIMESTAMP
TINYINT
UNIQUEIDENTIFIER
VARBINARY
VARCHAR
Tracy McKibben
MCDBA
http://www.realsqlguy.com
|||and here are a few more - but I'd love to know how to get hold of the whole
list because I'm not sure if all of the following entries are valid.
@.@.CONNECTIONS
@.@.CPU_BUSY
@.@.CURSOR_ROWS
@.@.DATEFIRST
@.@.DBTS
@.@.ERROR
@.@.FETCH_STATUS
@.@.IDENTITY
@.@.IDENTITY
@.@.IDLE
@.@.IO_BUSY
@.@.LANGID
@.@.LANGUAGE
@.@.LOCK_TIMEOUT
@.@.MAX_CONNECTIONS
@.@.MAX_PRECISION
@.@.NESTLEVEL
@.@.OPTIONS
@.@.PACK_RECEIVED
@.@.PACK_SENT
@.@.PACKET_ERRORS
@.@.PROCID
@.@.REMSERVER
@.@.ROWCOUNT
@.@.SERVERNAME
@.@.SERVICENAME
@.@.SPID
@.@.TEXTSIZE
@.@.TIMETICKS
@.@.TOTAL_ERRORS
@.@.TOTAL_READ
@.@.TOTAL_WRITE
@.@.TRANCOUNT
@.@.VERSION
AGGREGATE
APP_NAME
APPLICATION
APPLOCK_MODE
APPLOCK_TEST
ASSEMBLY
ASSEMBLYPROPERTY
ASYMMETRIC
BACKUP
BINARY_CHECKSUM
BINDING
CATCH
CERTIFICATE
CHECKSUM
CHECKSUM_AGG
COLLATIONPROPERTY
COLLECTION
COLUMNPROPERTY
COLUMNS_UPDATED
CONTAINS
CONTAINSTABLE
CONTEXT_INFO
CONTRACT
CONVERSATION
COUNT_BIG
CREDENTIAL
CROSS
CURRENT_REQUEST_ID
CURSOR_STATUS
DATABASE_PRINCIPAL_ID
DATABASEPROPERTY
DATABASEPROPERTYEX
DENSE_RANK
DENY
DIALOG
DISABLE
DISTRIBUTED
DMX
ENABLE
ENDPOINT
ERROR_LINE
ERROR_MESSAGE
ERROR_NUMBER
ERROR_PROCEDURE
ERROR_SEVERITY
ERROR_STATE
EVENT
EVENTDATA
FILE_ID
FILE_IDEX
FILE_NAME
FILEGROUP_ID
FILEGROUP_NAME
FILEGROUPPROPERTY
FILEPROPERTY
FORMATMESSAGE
FREETEXT
FREETEXTTABLE
FULLTEXT
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
FUNCTION
GET_TRANSMISSION_STATUS
GETUTCDATE
GO
GROUPING
HAS_DBACCESS
IDENT_CURRENT
INDEXKEY_PROPERTY
INDEXPROPERTY
IS_MEMBER
IS_SRVROLEMEMBER
ISDATE
ISNUMERIC
JOB
LEN
LOGIN
LOGINPROPERTY
MASTER
MDX
MESSAGE
MOVE
NEWID
NEWSEQUENTIALID
NOCOUNT
NOTIFICATION
NTILE
OBJECT_DEFINITION
OBJECTPROPERTY
OBJECTPROPERTYEX
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENXML
ORIGINAL_LOGIN
PARSENAME
PARTITION
PERCENT
PERMISSIONS
PUBLISHINGSERVERNAME
QUERY
QUEUE
QUOTENAME
RANK
READTEXT
RECEIVE
REMOTE
REPLACE
RESTORE
REVERT
ROLE
ROUTE
ROW_NUMBER
ROWCOUNT_BIG
ROWGUIDCOL
SCHEMA_ID
SCHEMA_NAME
SCHEME
SCOPE_IDENTITY
SEND
SERVERPROPERTY
SERVICE
SESSIONPROPERTY
SIGNATURE
SQL_VARIANT_PROPERTY
SQUARE
SSAS
SSIS
SSRS
STATS
STDEV
STDEVP
SUBSCRIPTION
SUSER_SID
SUSER_SNAME
SYMMETRIC
SYNONYM
TERTIARY_WEIGHTS
TIMER
TOP
TRIGGER_NESTLEVEL
TRY
TYPE
TYPE_ID
TYPE_NAME
TYPEPROPERTY
UNICODE
VAR
VARP
XACT_STATE
XML
XMLNAMESPACES
"Tracy McKibben" <tracy@.realsqlguy.com> wrote in message
news:45742754.2010900@.realsqlguy.com...
>s wrote:
> This is the list of words that are "colored" from a syntax highlighter
> plugin that I use on my website:
> ABSOLUTE
> ACTION
> ALLOCATE
> ARE
> ASSERTION
> AT
> AUTHORIZATION
> BOTH
> CASCADE
> CASCADED
> CAST
> CATALOG
> CHAR_LENGTH
> CHARACTER
> CHARACTER_LENGTH
> COLLATE
> COLLATION
> COLUMN
> CONNECT
> CONNECTION
> CONSTRAINTS
> CORRESPONDING
> DATE
> DAY
> DEFERRABLE
> DEFERRED
> DESCRIBE
> DESCRIPTOR
> DIAGNOSTICS
> DISCONNECT
> DOMAIN
> END_EXEC
> ESCAPE
> EXCEPTION
> EXPIREDATE
> EXTERNAL
> EXTRACT
> FALSE
> FILE
> FIRST
> FULL
> GET
> GLOBAL
> HOUR
> IMMEDIATE
> INITIALLY
> INNER
> INPUT
> INTERVAL
> JOIN
> LAST
> LEADING
> LEFT
> LOCAL
> MATCH
> MINUTE
> MONTH
> NAMES
> NATIONAL
> NATURAL
> NCHAR
> NEXT
> NO
> OCTET_LENGTH
> OUTER
> OUTPUT
> OVERLAPS
> PAD
> PARTIAL
> POSITION
> PRESERVE
> PRIOR
> PRIVILEGES
> RELATIVE
> RESTRICT
> RETAINDAYS
> RIGHT
> ROWS
> SCHEMA
> SECOND
> SESSION
> SIZE
> SPACE
> SQLSTATE
> TIME
> TIMEZONE_HOUR
> TIMEZONE_MINUTE
> TRAILING
> TRANSLATE
> TRANSLATION
> TRUE
> UNKNOWN
> USAGE
> USING
> VALUE
> VOLUME
> WORK
> WRITE
> YEAR
> ZONE
> ADD
> ALL
> ALTER
> AND
> ANY
> AS
> ASC
> AVG
> BEGIN
> BETWEEN
> BREAK
> BROWSE
> BULK
> BY
> CASE
> CHECK
> CHECKPOINT
> CLOSE
> CLUSTERED
> COALESCE
> COMMIT
> COMMITTED
> COMPUTE
> CONFIRM
> CONSTRAINT
> CONTINUE
> CONTROLROW
> CONVERT
> COUNT
> CREATE
> CURRENT
> CURRENT_DATE
> CURRENT_TIME
> CURRENT_TIMESTAMP
> CURRENT_USER
> CURSOR
> DATABASE
> DBCC
> DEALLOCATE
> DECLARE
> DEFAULT
> DELETE
> DESC
> DISK
> DISTINCT
> DOUBLE
> DROP
> DUMMY
> DUMP
> ELSE
> END
> ERRLVL
> ERROREXIT
> EXCEPT
> EXEC
> EXECUTE
> EXISTS
> EXIT
> FETCH
> FILLFACTOR
> FLOPPY
> FOR
> FOREIGN
> FROM
> GOTO
> GRANT
> GROUP
> HAVING
> HOLDLOCK
> IDENTITY
> IDENTITY_INSERT
> IDENTITYCOL
> IF
> IN
> INDEX
> INSENSITIVE
> INSERT
> INTERSECT
> INTO
> IS
> ISOLATION
> KEY
> KILL
> LEVEL
> LIKE
> LINENO
> LOAD
> MAX
> MIN
> MIRROREXIT
> NOCHECK
> NONCLUSTERED
> NOT
> NULL
> NULLIF
> OF
> OFF
> OFFSETS
> ON
> ONCE
> ONLY
> OPEN
> OPTION
> OR
> ORDER
> OVER
> PERM
> PERMANENT
> PIPE
> PLAN
> PRECISION
> PREPARE
> PRIMARY
> PRINT
> PROC
> PROCEDURE
> PROCESSEXIT
> PUBLIC
> RAISERROR
> READ
> RECONFIGURE
> REFERENCES
> REPEATABLE
> REPLICATION
> RETURN
> REVOKE
> ROLLBACK
> ROWCOUNT
> RULE
> SAVE
> SCROLL
> SELECT
> SERIALIZABLE
> SESSION_USER
> SET
> SETUSER
> SHUTDOWN
> SOME
> STATISTICS
> SUM
> SYSTEM_USER
> TABLE
> TAPE
> TEMP
> TEMPORARY
> TEXTSIZE
> THEN
> TO
> TRAN
> TRANSACTION
> TRIGGER
> TRUNCATE
> TSEQUAL
> UNCOMMITTED
> UNION
> UNIQUE
> UPDATE
> UPDATETEXT
> USE
> USER
> VALUES
> VARYING
> VIEW
> WAITFOR
> WHEN
> WHERE
> WHILE
> WITH
> WRITETEXT
> sp_column_privileges
> sp_special_columns
> sp_columns
> sp_sproc_columns
> sp_databases
> sp_statistics
> sp_datatype_info
> sp_stored_procedures
> sp_fkeys
> sp_table_privileges
> sp_pkeys
> sp_tables
> sp_server_info
> sp_addpublisher
> sp_dropsubscriber
> sp_addsubscriber
> sp_helpdistributor
> sp_changesubscriber
> sp_helpserver
> sp_dboption
> sp_helpsubscriberinfo
> sp_droppublisher
> sp_replsync
> sp_addarticle
> sp_helparticle
> sp_addpublication
> sp_helparticlecolumns
> sp_articlecolumn
> sp_helppublication
> sp_changearticle
> sp_helppublicationsync
> sp_changepublication
> sp_helpreplicationdb
> sp_droparticle
> sp_replflush
> sp_droppublication
> sp_replstatus
> sp_enumfullsubscribers
> sp_addsubscription
> sp_helpsubscription
> sp_changesubscription
> sp_subscribe
> sp_changesubstatus
> sp_unsubscribe
> sp_dropsubscription
> sp_distcounters
> sp_replica
> sp_replcleanup
> sp_MSkill_job
> sp_repldone
> sp_replcmds
> sp_repltrans
> sp_replcounters
> sp_addtask
> sp_helptask
> sp_droptask
> sp_addalert
> sp_helpalert
> sp_addnotification
> sp_helpnotification
> sp_addoperator
> sp_helpoperator
> sp_dropalert
> sp_updatealert
> sp_dropnotification
> sp_updatenotification
> sp_dropoperator
> sp_updateoperator
> sp_purgehistory
> sp_helphistory
> sp_updatetask
> sp_MSSQLOLE65_version
> sp_MSSQLOLE_version
> sp_MS_upd_sysobj_category
> sp_MSdbuserprofile
> sp_MSdependencies
> sp_MSenumsubsystems
> sp_MSfilterclause
> sp_MSforeach_worker
> sp_MSforeachdb
> sp_MSforeachtable
> sp_MSgetalertinfo
> sp_MSgetexecinfo
> sp_MShelpcolumns
> sp_MShelpindex
> sp_MShelptype
> sp_MSindexspace
> sp_MSkilldb
> sp_MSloginmappings
> sp_MSmatchkey
> sp_MSobjectprivs
> sp_MSsetalertinfo
> sp_MSsetexecinfo
> sp_MSsettopology
> sp_MSsubscriptions
> sp_MStablechecks
> sp_MStablekeys
> sp_MStablerefs
> sp_MStablespace
> sp_MSuninstall_publishing
> sp_MSuniquename
> sp_TDGEN_CURSOR1
> sp_TD_table_summary
> sp_TDaccess_server_drives
> sp_TDblocks
> sp_TDcheck_indexes
> sp_TDcheck_rowcount
> sp_TDdb_locks
> sp_TDdbsizes_data
> sp_TDdbsizes_log
> sp_TDdbsizes_total
> sp_TDdefault_db_audit
> sp_TDdevspace
> sp_TDdroplogin
> sp_TDformat_commas
> sp_TDget_logins
> sp_TDgetdbsizes
> sp_TDhelpdb
> sp_TDhelplogin
> sp_TDmirrorlogin
> sp_TDpassword_change
> sp_TDrunthis
> sp_TDspaceused
> sp_TDtable_sizes
> sp_TDupdate_stats
> sp_a_count_bits_on
> sp_abort_xact
> sp_add_app_user
> sp_addalias
> sp_addextendedproc
> sp_addgroup
> sp_addlanguage
> sp_addlogin
> sp_addmessage
> sp_addremotelogin
> sp_addsegment
> sp_addserver
> sp_addtype
> sp_addumpdevice
> sp_adduser
> sp_altermessage
> sp_articlefilter
> sp_articletextcol
> sp_articleview
> sp_bindefault
> sp_bindrule
> sp_blockcnt
> sp_certify_removable
> sp_change_users_login
> sp_changedbowner
> sp_changegroup
> sp_check_objects
> sp_check_removable
> sp_checknames
> sp_chklangparam
> sp_coalesce_fragments
> sp_commit_xact
> sp_commonkey
> sp_configure
> sp_create_distribution_tables
> sp_create_removable
> sp_db_locks
> sp_db_upgrade
> sp_db_upgrade1
> sp_db_upgrade2
> sp_db_upgrade3
> sp_dbinstall
> sp_dbremove
> sp_ddopen
> sp_defaultdb
> sp_defaultlanguage
> sp_depends
> sp_devcreate
> sp_devoption
> sp_diskdefault
> sp_dropalias
> sp_dropdevice
> sp_dropextendedproc
> sp_dropgroup
> sp_dropkey
> sp_droplanguage
> sp_droplogin
> sp_dropmessage
> sp_dropremotelogin
> sp_dropsegment
> sp_dropserver
> sp_droptype
> sp_dropuser
> sp_dropwebtask
> sp_dsninfo
> sp_dtdba_checkfull
> sp_dtdba_constraint
> sp_dtdba_createsql
> sp_dtdba_freedevice
> sp_dtdba_getobj
> sp_dtdba_getobjectpermissions
> sp_dtdba_gettabkey
> sp_dtdba_gettabper
> sp_dtdba_getuserpermissions
> sp_dtdba_helpcolumn
> sp_dtdba_helpcolumn2
> sp_dtdba_indexkeys
> sp_dtdba_userprotects
> sp_enumdsn
> sp_exec
> sp_extendsegment
> sp_fallback_MS_enroll_db
> sp_fallback_MS_enroll_dev
> sp_fallback_MS_enroll_usg
> sp_fallback_MS_sel_fb_svr
> sp_fallback_MS_verify_ri
> sp_fallback_activate_svr
> sp_fallback_deactivate_svr
> sp_fallback_deactivate_svr_db
> sp_fallback_enroll_svr_db
> sp_fallback_help
> sp_fallback_help_db_dev
> sp_fallback_permanent_svr
> sp_fallback_upd_dev_drive
> sp_fallback_withdraw_svr_db
> sp_fixindex
> sp_foreignkey
> sp_get_volume_label
> sp_hcchangesubstatus1
> sp_hcchangesubstatus2
> sp_help
> sp_help_revdatabase
> sp_helpconstraint
> sp_helpdb
> sp_helpdevice
> sp_helpextendedproc
> sp_helpgroup
> sp_helpindex
> sp_helpjoins
> sp_helpkey
> sp_helplanguage
> sp_helplog
> sp_helplogins
> sp_helpremotelogin
> sp_helprotect
> sp_helpsegment
> sp_helpsort
> sp_helpsql
> sp_helpstartup
> sp_helptext
> sp_helpuser
> sp_kill
> sp_lock
> sp_lock2
> sp_lockinfo
> sp_logdevice
> sp_lookup
> sp_makestartup
> sp_makewebtask
> sp_markreport
> sp_monitor
> sp_namecrack
> sp_namecrack_qi
> sp_objcheck
> sp_objectsegment
> sp_password
> sp_placeobject
> sp_primarykey
> sp_probe_xact
> sp_processinfo
> sp_processmail
> sp_publishdb
> sp_recompile
> sp_remoteoption
> sp_remove_xact
> sp_rename
> sp_renamedb
> sp_runwebtask
> sp_scan_xact
> sp_schedulersignal
> sp_serveroption
> sp_setlangalias
> sp_setnetname
> sp_spaceused
> sp_sqlexec
> sp_sqlregister
> sp_start_xact
> sp_stat_xact
> sp_sysbackuphistory_limiter
> sp_tableoption
> sp_tempdbspace
> sp_textcolstatus
> sp_unbindefault
> sp_unbindrule
> sp_unmakestartup
> sp_user_counter1
> sp_user_counter10
> sp_user_counter2
> sp_user_counter3
> sp_user_counter4
> sp_user_counter5
> sp_user_counter6
> sp_user_counter7
> sp_user_counter8
> sp_user_counter9
> sp_userdefcounters
> sp_validlang
> sp_validname
> sp_who
> sp_who2
> xp_enumgroups
> xp_logininfo
> xp_grantlogin
> xp_revokelogin
> xp_loginconfig
> xp_deletemail
> xp_sendmail
> xp_findnextmsg
> xp_startmail
> xp_readmail
> xp_stopmail
> xp_cmdshell
> xp_sprintf
> xp_logevent
> xp_sscanf
> xp_msver
> CONNECTIONS
> CPU_BUSY
> CURSOR_ROWS
> DATEFIRST
> DBTS
> ERROR
> FETCH_STATUS
> IDLE
> IO_BUSY
> LANGID
> LANGUAGE
> MAX_CONNECTIONS
> MAX_PRECISION
> MICROSOFTVERSION
> NESTLEVEL
> PACK_RECEIVED
> PACK_SENT
> PACKET_ERRORS
> PROCID
> REMSERVER
> SERVERNAME
> SERVICENAME
> SPID
> TIMETICKS
> TOTAL_ERRORS
> TOTAL_READ
> TOTAL_WRITE
> TRANCOUNT
> VERSION
> ABS
> ACOS
> ASCII
> ASIN
> ATAN
> ATN2
> COL_NAME
> CHARINDEX
> CHAR
> COT
> COS
> CEILING
> COL_LENGTH
> DB_NAME
> DB_ID
> DATALENGTH
> DIFFERENCE
> DATEADD
> DATENAME
> DATEDIFF
> DATEPART
> DEGREES
> EXP
> FLOOR
> GETANSINULL
> GETDATE
> HOST_ID
> HOST_NAME
> ISNULL
> INDEX_COL
> IDENT_SEED
> IDENT_INCR
> LOWER
> LTRIM
> LOG
> LOG10
> OBJECT_ID
> OBJECT_NAME
> PATINDEX
> POWER
> PI
> RTRIM
> REVERSE
> REPLICATE
> RADIANS
> RAND
> ROUND
> SUSER_NAME
> SUSER_ID
> STATS_DATE
> SUBSTRING
> STUFF
> STR
> SOUNDEX
> SIGN
> SIN
> SQRT
> TEXTVALID
> TEXTPTR
> TAN
> USER_NAME
> USER_ID
> UPPER
> BINARY
> BIT
> DATETIME
> DECIMAL
> FLOAT
> IMAGE
> INT
> MONEY
> NTEXT
> NUMERIC
> NVARCHAR
> REAL
> SMALLDATETIME
> SMALLMONEY
> TEXT
> TIMESTAMP
> TINYINT
> UNIQUEIDENTIFIER
> VARBINARY
> VARCHAR
>
>
> --
> Tracy McKibben
> MCDBA
> http://www.realsqlguy.com