From: Erland Sommarskog on
David Gugick (davidg-nospam(a)imceda.com) writes:
> Big TextPad fan as well. Just curious what SQL syntax file you're using
> with TextPad.

It's one that I got off the Textpad site several years ago. I've since
augmented it for SQL 2000. I've included the file below.




; SQL Server Transact SQL Syntax - Created by Tony Rabun
;<trabun(a)vbopensource.com>
;
; Augmented for AbaPerls and SQL2000 by Erland Sommarskog
; <esquel(a)sommarskog.se> with thanks to Gert Drapers for a list of
; SQL keywords
;
; The keyword list (Keywords 1) is SQL Server Reserved Keyword list.
; The column types (Keywords 2) represent SQL Server data types.
; SQL Server system stored and extended procedures are in Keywords 3.
; System functions (includýng "global variables" are in Keywords 4.
; Predefined Preppis macros is in Keywords 5 and Preppis directives
; under Preprocessor Keywords.



C=1

[Syntax]
Namespace1 = 6
IgnoreCase = yes
InitKeyWordChars = #@A-Za-z_
KeyWordChars = #@A-Za-z0-9_.
BracketChars = {[()]}
OperatorChars = -+*/<>!~%^|=
PreprocStart = $
SyntaxStart =
SyntaxEnd =
CommentStart = /*
CommentEnd = */
SingleComment = --
SingleCommentCol =
SingleCommentAlt =
SingleCommentColAlt =
StringStart = "
StringEnd = "
StringEsc =
StringsSpanLines = Yes
CharStart = '
CharEnd = '
CharEsc =

[Keywords 1]
ABSOLUTE
ADD
ALL
ACTION
AFTER
ANSI_DEFAULTS
ANSI_NULL_DFLT_OFF
ANSI_NULL_DFLT_ON
ANSI_NULLS
ANSI_PADDING
ANSI_WARNINGS
ALTER
AND
ANY
AS
ASC
ARITHABORT
ARITHIGNORE
AUTHORIZATION
AVG
BACKUP
BEGIN
BETWEEN
BREAK
BROWSE
BULK
BY
CASCADE
CASE
CHECK
CHECKPOINT
CHECKALLOC
CHECKCATALOG
CHECKDB
CHECKFILEGROUP
CHECKIDENT
CHECKTABLE
CLOSE
CLUSTERED
COALESCE
COLLATE
COLUMN
COMMIT
COMMITTED
COMPUTE
CONCAT_NULL_YIELDS_NULL
CONFIRM
CONSTRAINT
CONTAINS
CONTAINSTABLE
CONTINUE
CONTEXT_INFO
CREATE
CROSS
CUBE
CURRENT
CURSOR
DATABASE
DBCC
DEALLOCATE
DEADLOCK_PRIORITY
DECLARE
DEFAULT
DELETE
DELAY
DENY
DESC
DISK
DISTINCT
DISTRIBUTED
DOUBLE
DROP
DROP_EXISTING
DUMMY
DUMP
DYNAMIC
ELSE
ENCRYPTION
END
ERRLVL
ERROREXIT
ESCAPE
EXCEPT
EXEC
EXECUTE
EXISTS
EXIT
FAST_FORWARD
FETCH
FILE
FILLFACTOR
FIPS_FLAGGER
FIRST
FMTONLY
FORCEPLAN
FORWARD
FORWARD_ONLY
FOR
FOREIGN
FREETEXT
FREETEXTTABLE
FROM
FUNCTION
FUNCTIONS
FULL
FULLSCAN
GLOBAL
GOTO
GRANT
GROUP
HAVING
HOLDLOCK
IDENTITY
IDENTITY_INSERT
IDENTITYCOL
IF
IMPLICIT_TRANSACTIONS
IN
INDEX
INNER
INPUTBUFFER
INSERT
INTERSECT
INSENSITIVE
INSTEAD
INTO
IS
ISOLATION
JOIN
KEY
KEYSET
KILL
LEVEL
LIKE
LINENO
LOCAL
LOAD
MIRROREXIT
NATIONAL
NEWALLOC
NO
NO_LOG
NO_TRUNCATE
NOEXEC
NOCOUNT
NOCHECK
NUMERIC_ROUNDABORT
NONCLUSTERED
NOT
NULL
OF
OFF
OFFSETS
ON
ONCE
ONLY
OPEN
OPENDATASOURCE
OPENQUERY
OPENROWSET
OPENTRAN
OPENXML
OPTION
OR
ORDER
OUTER
OUT
OUTPUT
OUTPUTBUFFER
OVER
PAD_INDEX
PARSEONLY
PERCENT
PERM
PERMANENT
PIPE
PLAN
PRECISION
PREPARE
PRIMARY
PRINT
PRIVILEGES
PROC
PROCEDURE
PROCESSEXIT
PROCCACHE
QUARTER
QUERY_GOVERNOR_COST_LIMIT
QUOTED_IDENTIFIER
PUBLIC
RAISERROR
READ
READ_ONLY
READTEXT
RECOMPILE
RECONFIGURE
REFERENCES
REMOTE_PROC_TRANSACTIONS
REPEATABLE
REPLICATION
RESTORE
RESTRICT
RETURN
RETURNS
REVOKE
ROLLBACK
ROLLUP
ROWCOUNT
ROWGUIDCOL
RULE
SAVE
SCHEMA
SCHEMABINDING
SCROLL
SELECT
SERIALIZABLE
SESSION_USER
SET
SETUSER
SHUTDOWN
SHOWPLAN
SHOW_STATISTICS
SHOWCONTIG
SHOWPLAN
SHOWPLAN_ALL
SHOWPLAN_TEXT
SHRINKDATABASE
SHRINKDB
SHRINKFILE
SOME
STATISTICS
SORTED_DATA
SORTED_DATA_REORG
SQLPERF
STATIC
STATISTICS_NORECOMPUTE
SYSTEM_USER
TABLE
TAPE
TEMP
TEMPORARY
TEXTSIZE
THEN
TO
TOP
TRACEOFF
TRACEON
TRAN
TRANSACTION
TRIGGER
TRUNCATE
TSEQUAL
UNCOMMITTED
UNION
UNIQUE
UNPINTABLE
UPDATEUSAGE
USEROPTIONS
UPDATE
UPDATETEXT
USE
USER
VALUES
VARYING
VIEW
WAITFOR
WHEN
WHERE
WHILE
WITH
WORK
WRITETEXT
XACT_ABORT
XML
XMLDATA

[Keywords 2]
BIGINT
BINARY
BIT
CHAR
CHARACTER
DATETIME
DECIMAL
FLOAT
IMAGE
INT
INTEGER
MONEY
NCHAR
NTEXT
NUMERIC
NVARCHAR
REAL
ROWVERSION
SMALLDATETIME
SMALLINT
SMALLMONEY
SQL_VARIANT
TEXT
TINYINT
TIMESTAMP
UNIQUEIDENTIFIER
VARBINARY
VARCHAR

[Keywords 3]

FN_CHARISWHITESPACE
FN_DBLOG
FN_GENERATEPARAMETERPATTERN
FN_GETPERSISTEDSERVERNAMECASEVARIATION
FN_HELPCOLLATIONS
FN_ISREPLMERGEAGENT
FN_LISTEXTENDEDPROPERTY
FN_MSFULLTEXT
FN_MSGENSQESCSTR
FN_MSSHAREDVERSION
FN_REMOVEPARAMETERWITHARGUMENT
FN_REPLGETAGENTCOMMANDLINEFROMJOBID
FN_REPLGETBINARY8LODWORD
FN_REPLMAKESTRINGLITERAL
FN_REPLPREPADBINARY8
FN_REPLQUOTENAME
FN_REPLUNIQUENAME
FN_SERVERID
FN_SERVERSHAREDDRIVES
FN_SKIPPARAMETERARGUMENT
FN_SQLVARBASETOSTR
FN_TRACE_GETEVENTINFO
FN_TRACE_GETFILTERINFO
FN_TRACE_GETINFO
FN_TRACE_GETTABLE
FN_UPDATEPARAMETERWITHARGUMENT
FN_VARBINTOHEXSTR
FN_VARBINTOHEXSUBSTRING
FN_VIRTUALFILESTATS
FN_VIRTUALSERVERNODES
MS_SQLCTRS_USERS
SP_ACTIVEDIRECTORY_OBJ
SP_ACTIVEDIRECTORY_SCP
SP_ACTIVEDIRECTORY_START
SP_ADD_AGENT_PARAMETER
SP_ADD_AGENT_PROFILE
SP_ADD_DATA_FILE_RECOVER_SUSPECT_DB
SP_ADD_DATATYPE_MAPPING
SP_ADD_FILE_RECOVER_SUSPECT_DB
SP_ADD_LOG_FILE_RECOVER_SUSPECT_DB
SP_ADD_SERVER_SORTINFO
SP_ADD_SERVER_SORTINFO75
SP_ADDALIAS
SP_ADDAPPROLE
SP_ADDARTICLE
SP_ADDDISTPUBLISHER
SP_ADDDISTRIBUTIONDB
SP_ADDDISTRIBUTOR
SP_ADDEXTENDEDPROC
SP_ADDEXTENDEDPROPERTY
SP_ADDGROUP
SP_ADDLINKEDSERVER
SP_ADDLINKEDSRVLOGIN
SP_ADDLOGIN
SP_ADDMERGEALTERNATEPUBLISHER
SP_ADDMERGEARTICLE
SP_ADDMERGEFILTER
SP_ADDMERGEPUBLICATION
SP_ADDMERGEPULLSUBSCRIPTION
SP_ADDMERGEPULLSUBSCRIPTION_AGENT
SP_ADDMERGESUBSCRIPTION
SP_ADDMESSAGE
SP_ADDPUBLICATION
SP_ADDPUBLICATION_SNAPSHOT
SP_ADDPUBLISHER
SP_ADDPULLSUBSCRIPTION
SP_ADDPULLSUBSCRIPTION_AGENT
SP_ADDQUEUED_ARTINFO
SP_ADDREMOTELOGIN
SP_ADDROLE
SP_ADDROLEMEMBER
SP_ADDSCRIPTEXEC
SP_ADDSERVER
SP_ADDSRVROLEMEMBER
SP_ADDSUBSCRIBER
SP_ADDSUBSCRIBER_SCHEDULE
SP_ADDSUBSCRIPTION
SP_ADDSYNCTRIGGERS
SP_ADDTABLETOCONTENTS
SP_ADDTYPE
SP_ADDUMPDEVICE
SP_ADDUSER
SP_ADJUSTPUBLISHERIDENTITYRANGE
SP_ALTERMESSAGE
SP_APPROLEPASSWORD
SP_ARTICLE_VALIDATION
SP_ARTICLECOLUMN
SP_ARTICLEFILTER
SP_ARTICLESYNCTRANPROCS
SP_ARTICLEVIEW
SP_ATTACH_DB
SP_ATTACH_SINGLE_FILE_DB
SP_ATTACHSUBSCRIPTION
SP_AUTOSTATS
SP_BCP_DBCMPTLEVEL
SP_BINDEFAULT
SP_BINDRULE
SP_BINDSESSION
SP_BLOCKCNT
SP_BROWSEMERGESNAPSHOTFOLDER
SP_BROWSESNAPSHOTFOLDER
SP_CATALOGS
SP_CATALOGS_ROWSET
SP_CERTIFY_REMOVABLE
SP_CHANGE_AGENT_PARAMETER
SP_CHANGE_AGENT_PROFILE
SP_CHANGE_SUBSCRIPTION_PROPERTIES
SP_CHANGE_USERS_LOGIN
SP_CHANGEARTICLE
SP_CHANGEDBOWNER
SP_CHANGEDISTPUBLISHER
SP_CHANGEDISTRIBUTIONDB
SP_CHANGEDISTRIBUTOR_PASSWORD
SP_CHANGEDISTRIBUTOR_PROPERTY
SP_CHANGEGROUP
SP_CHANGEMERGEARTICLE
SP_CHANGEMERGEFILTER
SP_CHANGEMERGEPUBLICATION
SP_CHANGEMERGEPULLSUBSCRIPTION
SP_CHANGEMERGESUBSCRIPTION
SP_CHANGEOBJECTOWNER
SP_CHANGEPUBLICATION
SP_CHANGESUBSCRIBER
SP_CHANGESUBSCRIBER_SCHEDULE
SP_CHANGESUBSCRIPTION
SP_CHANGESUBSCRIPTIONDTSINFO
SP_CHANGESUBSTATUS
SP_CHECK_CONSTBYTABLE_ROWSET
SP_CHECK_CONSTRAINTS_ROWSET
SP_CHECK_FOR_SYNC_TRIGGER
SP_CHECK_PUBLICATION_ACCESS
SP_CHECK_REMOVABLE
SP_CHECK_REMOVABLE_SYSUSERS
SP_CHECK_SYNC_TRIGGER
SP_CHECKNAMES
SP_CLEANUPDBREPLICATION
SP_CLEANUPWEBTASK
SP_COLUMN_PRIVILEGES
SP_COLUMN_PRIVILEGES_EX
SP_COLUMN_PRIVILEGES_ROWSET
SP_COLUMNS
SP_COLUMNS_EX
SP_COLUMNS_ROWSET
SP_CONFIGURE
SP_CONVERTWEBTASKS
SP_COPYMERGESNAPSHOT
SP_COPYSNAPSHOT
SP_COPYSUBSCRIPTION
SP_CREATE_REMOVABLE
SP_CREATEORPHAN
SP_CREATESTATS
SP_CURSOR
SP_CURSOR_LIST
SP_CURSORCLOSE
SP_CURSOREXECUTE
SP_CURSORFETCH
SP_CURSOROPEN
SP_CURSOROPTION
SP_CURSORPREPARE
SP_CURSORPREPEXEC
SP_CURSORUNPREPARE
SP_CYCLE_ERRORLOG
SP_DATABASES
SP_DATATYPE_INFO
SP_DB_UPGRADE
SP_DBCMPTLEVEL
SP_DBFIXEDROLEPERMISSION
SP_DBOPTION
SP_DBREMOVE
SP_DDOPEN
SP_DEFAULTDB
SP_DEFAULTLANGUAGE
SP_DELETEMERGECONFLICTROW
SP_DENYLOGIN
SP_DEPENDS
SP_DESCRIBE_CURSOR
SP_DESCRIBE_CURSOR_COLUMNS
SP_DESCRIBE_CURSOR_TABLES
SP_DETACH_DB
SP_DISABLEAGENTOFFLOAD
SP_DISKDEFAULT
SP_DISTCOUNTERS
SP_DROP_AGENT_PARAMETER
SP_DROP_AGENT_PROFILE
SP_DROPALIAS
SP_DROPANONYMOUSAGENT
SP_DROPAPPROLE
SP_DROPARTICLE
SP_DROPDEVICE
SP_DROPDISTPUBLISHER
SP_DROPDISTRIBUTIONDB
SP_DROPDISTRIBUTOR
SP_DROPEXTENDEDPROC
SP_DROPEXTENDEDPROPERTY
SP_DROPGROUP
SP_DROPLINKEDSRVLOGIN
SP_DROPLOGIN
SP_DROPMERGEALTERNATEPUBLISHER
SP_DROPMERGEARTICLE
SP_DROPMERGEFILTER
SP_DROPMERGEPUBLICATION
SP_DROPMERGEPULLSUBSCRIPTION
SP_DROPMERGESUBSCRIPTION
SP_DROPMESSAGE
SP_DROPORPHANS
SP_DROPPUBLICATION
SP_DROPPUBLISHER
SP_DROPPULLSUBSCRIPTION
SP_DROPREMOTELOGIN
SP_DROPROLE
SP_DROPROLEMEMBER
SP_DROPSERVER
SP_DROPSRVROLEMEMBER
SP_DROPSUBSCRIBER
SP_DROPSUBSCRIPTION
SP_DROPTYPE
SP_DROPUSER
SP_DROPWEBTASK
SP_DSNINFO
SP_ENABLEAGENTOFFLOAD
SP_ENUM_OLEDB_PROVIDERS
SP_ENUMCODEPAGES
SP_ENUMCUSTOMRESOLVERS
SP_ENUMDSN
SP_ENUMERRORLOGS
SP_ENUMFULLSUBSCRIBERS
SP_ENUMOLEDBDATASOURCES
SP_EVENTLOG
SP_EXECUTE
SP_EXECUTESQL
SP_EXPIRED_SUBSCRIPTION_CLEANUP
SP_FALLBACK_MS_SEL_FB_SVR
SP_FETCHSHOWCMDSINPUT
SP_FIXINDEX
SP_FKEYS
SP_FOREIGN_KEYS_ROWSET
SP_FOREIGNKEYS
SP_FULLTEXT_CATALOG
SP_FULLTEXT_COLUMN
SP_FULLTEXT_DATABASE
SP_FULLTEXT_GETDATA
SP_FULLTEXT_SERVICE
SP_FULLTEXT_TABLE
SP_GENERATE_AGENT_PARAMETER
SP_GENERATEFILTERS
SP_GET_DISTRIBUTOR
SP_GETAGENTOFFLOADINFO
SP_GETAPPLOCK
SP_GETARTICLEPKCOLBITMAP
SP_GETBINDTOKEN
SP_GETMBCSCHARLEN
SP_GETMERGEDELETETYPE
SP_GETQUEUEDROWS
SP_GETSCHEMALOCK
SP_GETSUBSCRIPTIONDTSPACKAGENAME
SP_GETTYPESTRING
SP_GRANT_PUBLICATION_ACCESS
SP_GRANTDBACCESS
SP_GRANTLOGIN
SP_HELP
SP_HELP_AGENT_DEFAULT
SP_HELP_AGENT_PARAMETER
SP_HELP_AGENT_PROFILE
SP_HELP_DATATYPE_MAPPING
SP_HELP_FULLTEXT_CATALOGS
SP_HELP_FULLTEXT_CATALOGS_CURSOR
SP_HELP_FULLTEXT_COLUMNS
SP_HELP_FULLTEXT_COLUMNS_CURSOR
SP_HELP_FULLTEXT_TABLES
SP_HELP_FULLTEXT_TABLES_CURSOR
SP_HELP_PUBLICATION_ACCESS
SP_HELPALLOWMERGE_PUBLICATION
SP_HELPARTICLE
SP_HELPARTICLECOLUMNS
SP_HELPARTICLEDTS
SP_HELPCONSTRAINT
SP_HELPDB
SP_HELPDBFIXEDROLE
SP_HELPDEVICE
SP_HELPDISTPUBLISHER
SP_HELPDISTRIBUTIONDB
SP_HELPDISTRIBUTOR
SP_HELPDISTRIBUTOR_PROPERTIES
SP_HELPEXTENDEDPROC
SP_HELPFILE
SP_HELPFILEGROUP
SP_HELPGROUP
SP_HELPINDEX
SP_HELPLANGUAGE
SP_HELPLINKEDSRVLOGIN
SP_HELPLOG
SP_HELPLOGINS
SP_HELPMERGEALTERNATEPUBLISHER
SP_HELPMERGEARTICLE
SP_HELPMERGEARTICLECOLUMN
SP_HELPMERGEARTICLECONFLICTS
SP_HELPMERGECONFLICTROWS
SP_HELPMERGEDELETECONFLICTROWS
SP_HELPMERGEFILTER
SP_HELPMERGEPUBLICATION
SP_HELPMERGEPULLSUBSCRIPTION
SP_HELPMERGESUBSCRIPTION
SP_HELPNTGROUP
SP_HELPPUBLICATION
SP_HELPPUBLICATIONSYNC
SP_HELPPULLSUBSCRIPTION
SP_HELPREMOTELOGIN
SP_HELPREPLFAILOVERMODE
SP_HELPREPLICATIONDB
SP_HELPREPLICATIONDBOPTION
SP_HELPREPLICATIONOPTION
SP_HELPROLE
SP_HELPROLEMEMBER
SP_HELPROTECT
SP_HELPSERVER
SP_HELPSORT
SP_HELPSQL
SP_HELPSRVROLE
SP_HELPSRVROLEMEMBER
SP_HELPSTATS
SP_HELPSUBSCRIBERINFO
SP_HELPSUBSCRIPTION
SP_HELPSUBSCRIPTION_PROPERTIES
SP_HELPTEXT
SP_HELPTRIGGER
SP_HELPUSER
SP_INDEXES
SP_INDEXES_ROWSET
SP_INDEXOPTION
SP_INVALIDATE_TEXTPTR
SP_ISARTICLECOLBITSET
SP_ISMBCSLEADBYTE
SP_IVINDEXHASNULLCOLS
SP_LINK_PUBLICATION
SP_LINKEDSERVERS
SP_LINKEDSERVERS_ROWSET
SP_LOCK
SP_LOGDEVICE
SP_MAKEWEBTASK
SP_MARKSUBSCRIPTIONVALIDATION
SP_MERGEARTICLECOLUMN
SP_MERGECLEANUPMETADATA
SP_MERGEDUMMYUPDATE
SP_MERGESUBSCRIPTION_CLEANUP
SP_MONITOR
SP_MS_MARKSYSTEMOBJECT
SP_MS_REPLICATION_INSTALLED
SP_MS_UPD_SYSOBJ_CATEGORY
SP_MSACQUIREHEADOFQUEUELOCK
SP_MSACQUIRESERVERRESOURCEFORDYNAMICSNAPSHOT
SP_MSACQUIRESLOTLOCK
SP_MSACTIVATE_AUTO_SUB
SP_MSADD_COMPENSATING_CMD
SP_MSADD_DISTRIBUTOR_ALERTS_AND_RESPONSES
SP_MSADD_MERGEREPLCOMMAND
SP_MSADD_REPL_JOB
SP_MSADDANONYMOUSREPLICA
SP_MSADDEXECARTICLE
SP_MSADDGUIDCOLUMN
SP_MSADDGUIDINDEX
SP_MSADDINITIALARTICLE
SP_MSADDINITIALPUBLICATION
SP_MSADDINITIALSCHEMAARTICLE
SP_MSADDINITIALSUBSCRIPTION
SP_MSADDLOGIN_IMPLICIT_NTLOGIN
SP_MSADDMERGEDYNAMICSNAPSHOTJOB
SP_MSADDMERGEPUB_SNAPSHOT
SP_MSADDMERGESCHEMAARTICLE
SP_MSADDMERGETRIGGERS
SP_MSADDOFFLOADPARAMETER
SP_MSADDPUB_SNAPSHOT
SP_MSADDPUBTOCONTENTS
SP_MSADDSCHEMAARTICLE
SP_MSADDUPDATETRIGGER
SP_MSADDUSER_IMPLICIT_NTLOGIN
SP_MSADJUSTMERGEIDENTITY
SP_MSAGENT_ACCESS_CHECK
SP_MSALREADYHAVEGENERATION
SP_MSAREALLCOLUMNSCOMPUTED
SP_MSARTICLECLEANUP
SP_MSARTICLECOL
SP_MSARTICLECOLSTATUS
SP_MSBELONGS
SP_MSBUMPUPCOMPLEVEL
SP_MSCHANGE_PRIORITY
SP_MSCHANGE_RETENTION
SP_MSCHANGEARTICLERESOLVER
SP_MSCHANGEMERGESCHEMAARTICLE
SP_MSCHANGEOBJECTOWNER
SP_MSCHANGESCHEMAARTICLE
SP_MSCHECK_AGENT_INSTANCE
SP_MSCHECK_SUBSCRIPTION
SP_MSCHECK_UID_OWNS_ANYTHING
SP_MSCHECKATPUBLISHER
SP_MSCHECKEXISTSGENERATION
SP_MSCHECKIDENTITYRANGE
SP_MSCHECKMERGEREPLICATION
SP_MSCHECKMETADATAMATCH
SP_MSCHECKSNAPSHOTSTATUS
SP_MSCHECKVALIDSYSTABLES
SP_MSCLEANUP_CONFLICT
SP_MSCLEANUP_CONFLICT_TABLE
SP_MSCLEANUP_METADATA
SP_MSCLEANUPDYNSNAPSHOTVWS
SP_MSCLEANUPFORPULLREINIT
SP_MSCLEANUPMERGEPUBLISHER
SP_MSCLEANUPMERGEPUBLISHERDB
SP_MSCLEANUPTASK
SP_MSCLEARCOLUMNBIT
SP_MSCOMPUTEARTICLESCREATIONORDER
SP_MSCOMPUTEMERGEARTICLESCREATIONORDER
SP_MSCOMPUTEMERGEUNRESOLVEDREFS
SP_MSCOMPUTEUNRESOLVEDREFS
SP_MSCONTRACTSUBSNB
SP_MSCOPYREGVALUE
SP_MSCOPYSCRIPTFILE
SP_MSCOPYSNAPSHOT
SP_MSCREATE_DIST_TABLES
SP_MSCREATE_DISTRIBUTOR_TABLES
SP_MSCREATE_MERGESYSTABLES
SP_MSCREATE_PUB_TABLES
SP_MSCREATE_REPLICATION_CHECKUP_AGENT
SP_MSCREATE_REPLICATION_STATUS_TABLE
SP_MSCREATE_SUB_TABLES
SP_MSCREATEBEFORETABLE
SP_MSCREATEGLOBALREPLICA
SP_MSCREATERETRY
SP_MSDBUSERACCESS
SP_MSDBUSERPRIV
SP_MSDEFER_CHECK
SP_MSDELETECONTENTS
SP_MSDELETEPUSHAGENT
SP_MSDELETERETRY
SP_MSDELETETRANCONFLICTROW
SP_MSDELGENZERO
SP_MSDELROW
SP_MSDELSUBROWS
SP_MSDELSUBROWSBATCH
SP_MSDEPENDENCIES
SP_MSDOESFILTERHAVEPARENT
SP_MSDROP_6X_REPLICATION_AGENT
SP_MSDROP_DISTRIBUTOR_ALERTS_AND_RESPONSES
SP_MSDROP_EXPIRED_MERGESUBSCRIPTION
SP_MSDROP_EXPIRED_SUBSCRIPTION
SP_MSDROP_MERGESYSTABLES
SP_MSDROP_OBJECT
SP_MSDROP_PUB_TABLES
SP_MSDROP_REPLCOM
SP_MSDROP_REPLTRAN
SP_MSDROP_RLADMIN
SP_MSDROP_RLCORE
SP_MSDROP_RLRECON
SP_MSDROPARTICLECONSTRAINTS
SP_MSDROPARTICLEPROCS
SP_MSDROPARTICLETOMBSTONES
SP_MSDROPARTICLETRIGGERS
SP_MSDROPCONSTRAINTS
SP_MSDROPDYNSNAPSHOTVWS
SP_MSDROPFKREFERENCINGARTICLE
SP_MSDROPMERGEDYNAMICSNAPSHOTJOB
SP_MSDROPMERGEPUB_SNAPSHOT
SP_MSDROPRETRY
SP_MSDROPTEMPTABLE
SP_MSDUMMYUPDATE
SP_MSENUM_MISC_AGENTS
SP_MSENUM_REPLICATION_AGENTS
SP_MSENUM_REPLICATION_JOB
SP_MSENUM_REPLQUEUES
SP_MSENUM_REPLSQLQUEUES
SP_MSENUM3RDPARTYPUBLICATIONS
SP_MSENUMALLPUBLICATIONS
SP_MSENUMALLSUBSCRIPTIONS
SP_MSENUMCHANGES
SP_MSENUMCOLUMNS
SP_MSENUMDELETESMETADATA
SP_MSENUMGENERATIONS
SP_MSENUMMERGEPUBLICATIONS
SP_MSENUMPARTIALCHANGES
SP_MSENUMPARTIALDELETES
SP_MSENUMPUBREFERENCES
SP_MSENUMREPLICAS
SP_MSENUMRETRIES
SP_MSENUMSCHEMACHANGE
SP_MSENUMSCHEMACHANGE_70
SP_MSENUMSCHEMACHANGE_80
SP_MSENUMSUBSCRIPTIONS
SP_MSENUMTHIRDPARTYPUBLICATIONVENDORNAMES
SP_MSENUMTRANPUBLICATIONS
SP_MSESTIMATEMERGESNAPSHOTWORKLOAD
SP_MSESTIMATESNAPSHOTWORKLOAD
SP_MSEVALSUBSCRIBERINFO
SP_MSEXCLAUSE
SP_MSEXPANDBELONGS
SP_MSEXPANDNOTBELONGS
SP_MSEXPANDSUBSNB
SP_MSEXTERNALFKREFERENCES
SP_MSFETCHIDENTITYRANGE
SP_MSFILLUPMISSINGCOLS
SP_MSFILTERCLAUSE
SP_MSFIX_6X_TASKS
SP_MSFIXLINEAGEVERSIONS
SP_MSFIXUPAGENTOFFLOADINFO
SP_MSFIXUPALTSNAPSHOTFOLDER
SP_MSFIXUPDISTRIBUTORINFO
SP_MSFIXUPDISTRIBUTORSECURITY
SP_MSFIXUPFTPINFO
SP_MSFIXUPSHAREDAGENTPROPERTIES
SP_MSFIXUPUSEFTP
SP_MSFIXUPWORKINGDIRECTORY
SP_MSFLUSH_ACCESS_CACHE
SP_MSFLUSH_COMMAND
SP_MSFOREACH_WORKER
SP_MSFOREACHDB
SP_MSFOREACHTABLE
SP_MSGEN_SYNC_TRAN_PROCS
SP_MSGENREPLNICKNAME
SP_MSGENTABLENICKNAME
SP_MSGET_AGENT_NAMES
SP_MSGET_ATTACH_STATE
SP_MSGET_COL_POSITION
SP_MSGET_COLINFO
SP_MSGET_CURRENT_ACTIVITY
SP_MSGET_FILE_EXISTENCE
SP_MSGET_JOBSTATE
SP_MSGET_LOAD_HINT
SP_MSGET_MAP_POSITION
SP_MSGET_MERGEPULLSUBSAGENT_OWNER
SP_MSGET_OLEDBINFO
SP_MSGET_PUBLICATION_FROM_TASKNAME
SP_MSGET_PUBLISHER_RPC
SP_MSGET_PULLSUBSAGENT_OWNER
SP_MSGET_QUALIFIED_NAME
SP_MSGET_SETUP_PATHS
SP_MSGET_SHARED_AGENT
SP_MSGET_SUBTYPEDATASRC
SP_MSGET_SYNCTRAN_COLUMN
SP_MSGET_SYNCTRAN_COMMANDS
SP_MSGET_TYPE
SP_MSGETALERTINFO
SP_MSGETARTICLEREINITVALUE
SP_MSGETBEFORETABLEINSERT
SP_MSGETCHANGECOUNT
SP_MSGETCOLORDINALFROMCOLNAME
SP_MSGETCOLUMNLIST
SP_MSGETCONFLICTINSERTPROC
SP_MSGETCONFLICTTABLENAME
SP_MSGETLASTRECGEN
SP_MSGETLASTSENTGEN
SP_MSGETLASTSENTRECGENS
SP_MSGETLASTUPDATEDTIME
SP_MSGETMERGELASTUPDATEDTIME
SP_MSGETMETADATABATCH
SP_MSGETONEROW
SP_MSGETPUBINFO
SP_MSGETREPLICAINFO
SP_MSGETREPLNICK
SP_MSGETROWMETADATA
SP_MSGETSERVERPROPERTIES
SP_MSGETSUBSCRIBERINFO
SP_MSGETTABLECONTENTS
SP_MSGETTOOLS_PATH
SP_MSGETTRANCFTSRCROW
SP_MSGETTRANCONFLICTNAME
SP_MSGETTRANCONFLICTROW
SP_MSGETTRANLASTUPDATEDTIME
SP_MSGETTYPESTRINGUDT
SP_MSGETVERSION
SP_MSGETVIEWCOLUMNLIST
SP_MSGUIDTOSTR
SP_MSHASDBACCESS
SP_MSHELP_DISTDB
SP_MSHELP_IDENTITY_PROPERTY
SP_MSHELP_REPLICATION_STATUS
SP_MSHELP_REPLICATION_TABLE
SP_MSHELPALTERBEFORETABLE
SP_MSHELPCOLUMNS
SP_MSHELPCONFLICTPUBLICATIONS
SP_MSHELPCREATEBEFORETABLE
SP_MSHELPDESTOWNER
SP_MSHELPFULLTEXTINDEX
SP_MSHELPFULLTEXTSCRIPT
SP_MSHELPINDEX
SP_MSHELPMERGEARTICLES
SP_MSHELPMERGECONFLICTCOUNTS
SP_MSHELPMERGECONFLICTPUBLICATIONS
SP_MSHELPMERGEDYNAMICSNAPSHOTJOB
SP_MSHELPMERGEIDENTITY
SP_MSHELPMERGESCHEMAARTICLES
SP_MSHELPOBJECTPUBLICATIONS
SP_MSHELPTRANCONFLICTCOUNTS
SP_MSHELPTRANCONFLICTPUBLICATIONS
SP_MSHELPTYPE
SP_MSHELPVALIDATIONDATE
SP_MSIFEXISTSREMOTELOGIN
SP_MSINDEXCOLFROMBIN
SP_MSINDEXSPACE
SP_MSINIT_REPLICATION_PERFMON
SP_MSINIT_SUBSCRIPTION_AGENT
SP_MSINITDYNAMICSUBSCRIBER
SP_MSINSERTBEFOREIMAGECLAUSE
SP_MSINSERTCONTENTS
SP_MSINSERTDELETECONFLICT
SP_MSINSERTERRORLINEAGE
SP_MSINSERTGENERATIONSCHEMACHANGES
SP_MSINSERTGENHISTORY
SP_MSINSERTSCHEMACHANGE
SP_MSINSTANCE_QV
SP_MSIS_COL_REPLICATED
SP_MSIS_IDENTITY_INSERT
SP_MSIS_PK_COL
SP_MSISPKUPDATEINCONFLICT
SP_MSKILLDB
SP_MSLOAD_REPLICATION_STATUS
SP_MSLOCALIZEINTERRUPTEDGENERATIONS
SP_MSLOCKTABLE
SP_MSLOGINMAPPINGS
SP_MSMAKEARTICLEPROCS
SP_MSMAKECONFLICTINSERTPROC
SP_MSMAKECONFLICTTABLE
SP_MSMAKECTSVIEW
SP_MSMAKEDYNSNAPSHOTVWS
SP_MSMAKEEXPANDPROC
SP_MSMAKEGENERATION
SP_MSMAKEINSERTPROC
SP_MSMAKEJOINFILTER
SP_MSMAKESELECTPROC
SP_MSMAKESYSTABLEVIEWS
SP_MSMAKETEMPINSERTPROC
SP_MSMAKETRANCFTPROC
SP_MSMAKEUPDATEPROC
SP_MSMAKEVIEWPROC
SP_MSMAPTYPE
SP_MSMARK_PROC_NOREPL
SP_MSMARKREPLINFO
SP_MSMARKSCHEMAOBJECT
SP_MSMATCHKEY
SP_MSMERGEPUBLISHDB
SP_MSMERGESUBSCRIBEDB
SP_MSMERGEUPDATELASTSYNCINFO
SP_MSOBJECTPRIVS
SP_MSOBJSEARCH
SP_MSPAD_COMMAND
SP_MSPOST_AUTO_PROC
SP_MSPREP_EXCLUSIVE
SP_MSPREPARE_MERGEARTICLE
SP_MSPREPARE_SUB_FOR_DETACH
SP_MSPROXIEDMETADATA
SP_MSPUB_ADJUST_IDENTITY
SP_MSPUBLICATIONCLEANUP
SP_MSPUBLICATIONVIEW
SP_MSPUBLISHDB
SP_MSQUERYSUBTYPE
SP_MSREENABLE_CHECK
SP_MSREFCNT
SP_MSREGISTERSUBSCRIPTION
SP_MSREINIT_ARTICLE
SP_MSREINIT_FAILED_SUBSCRIPTIONS
SP_MSREINIT_HUB
SP_MSREINITMERGEPUBLICATION
SP_MSRELEASESLOTLOCK
SP_MSREMOVE_MERGEREPLCOMMAND
SP_MSREMOVE_USERSCRIPT
SP_MSREMOVEDBREPLICATION
SP_MSREMOVEOFFLOADPARAMETER
SP_MSREPL_ADDROLEMEMBER
SP_MSREPL_BACKUP_COMPLETE
SP_MSREPL_BACKUP_START
SP_MSREPL_CHECK_SERVER
SP_MSREPL_DBROLE
SP_MSREPL_DROPROLEMEMBER
SP_MSREPL_GETTYPE_MAPPINGS
SP_MSREPL_ISDBOWNER
SP_MSREPL_LINKEDSERVERS_ROWSET
SP_MSREPL_SCHEMA
SP_MSREPL_STARTUP
SP_MSREPL_VALIDATE_DTS_PACKAGE
SP_MSREPLCHECK_CONNECTION
SP_MSREPLCHECK_NAME
SP_MSREPLCHECK_PERMISSION
SP_MSREPLCHECK_PUBLISH
SP_MSREPLCHECK_PULL
SP_MSREPLCHECK_QV
SP_MSREPLCHECK_SUBSCRIBE
SP_MSREPLCHECKOFFLOADSERVER
SP_MSREPLICATIONCOMPATLEVEL
SP_MSREPLRAISERROR
SP_MSREPLROLE
SP_MSREPLSUP_TABLE_HAS_PK
SP_MSREPLUPDATESCHEMA
SP_MSRESEED
SP_MSRESET_ATTACH_STATE
SP_MSRESET_QUEUE
SP_MSRESET_QUEUED_REINIT
SP_MSRESET_SYNCTRAN_BIT
SP_MSRESTORE_SUB
SP_MSRESTORE_SUB_MERGE
SP_MSRESTORE_SUB_TRAN
SP_MSRETRIEVE_MERGEPUBLICATION
SP_MSRETRIEVE_PUBLICATION
SP_MSRETRIEVE_PUBLICATION_ATTRIBUTES
SP_MSSCRIPT_ARTICLE_VIEW
SP_MSSCRIPT_BEGINPROC
SP_MSSCRIPT_BEGINTRIG1
SP_MSSCRIPT_BEGINTRIG2
SP_MSSCRIPT_COMPENSATING_INSERT
SP_MSSCRIPT_COMPENSATING_SEND
SP_MSSCRIPT_DELETE_PUBWINS
SP_MSSCRIPT_DELETE_STATEMENT
SP_MSSCRIPT_DELETE_SUBWINS
SP_MSSCRIPT_DRI
SP_MSSCRIPT_ENDPROC
SP_MSSCRIPT_ENDTRIG
SP_MSSCRIPT_EXECUTIONMODE_STMT
SP_MSSCRIPT_INSERT_PUBWINS
SP_MSSCRIPT_INSERT_STATEMENT
SP_MSSCRIPT_INSERT_SUBWINS
SP_MSSCRIPT_MISSING_ROW_CHECK
SP_MSSCRIPT_MULTIROW_TRIGGER
SP_MSSCRIPT_PARAMS
SP_MSSCRIPT_PKVAR_ASSIGNMENT
SP_MSSCRIPT_PROCBODYSTART
SP_MSSCRIPT_PUB_UPD_TRIG
SP_MSSCRIPT_SECURITY
SP_MSSCRIPT_SINGLEROW_TRIGGER
SP_MSSCRIPT_SYNC_DEL_PROC
SP_MSSCRIPT_SYNC_DEL_TRIG
SP_MSSCRIPT_SYNC_INS_PROC
SP_MSSCRIPT_SYNC_INS_TRIG
SP_MSSCRIPT_SYNC_UPD_PROC
SP_MSSCRIPT_SYNC_UPD_TRIG
SP_MSSCRIPT_TRIGGER_ASSIGNMENT
SP_MSSCRIPT_TRIGGER_EXEC_RPC
SP_MSSCRIPT_TRIGGER_FETCH_STATEMENT
SP_MSSCRIPT_TRIGGER_UPDATE_CHECKS
SP_MSSCRIPT_TRIGGER_UPDATES
SP_MSSCRIPT_TRIGGER_VARIABLES
SP_MSSCRIPT_TRIGGER_VERSION_UPDATES
SP_MSSCRIPT_UPDATE_PUBWINS
SP_MSSCRIPT_UPDATE_STATEMENT
SP_MSSCRIPT_UPDATE_SUBWINS
SP_MSSCRIPT_VALIDATE_SUBSCRIPTION
SP_MSSCRIPT_WHERE_CLAUSE
SP_MSSCRIPTDATABASE
SP_MSSCRIPTDB_WORKER
SP_MSSCRIPTMVASTABLE
SP_MSSCRIPTMVASTABLEIDX
SP_MSSCRIPTMVASTABLENCI
SP_MSSCRIPTMVASTABLEPKC
SP_MSSENDTOSQLQUEUE
SP_MSSET_CURRENT_ACTIVITY
SP_MSSET_SUB_GUID
SP_MSSET_SUBSCRIPTION_PROPERTIES
SP_MSSETACCESSLIST
SP_MSSETALERTINFO
SP_MSSETARTPROCS
SP_MSSETBIT
SP_MSSETCONFLICTSCRIPT
SP_MSSETCONFLICTTABLE
SP_MSSETCONTEXT_REPLAGENT
SP_MSSETFILTEREDSTATUS
SP_MSSETFILTERPARENT
SP_MSSETLASTRECGEN
SP_MSSETLASTSENTGEN
SP_MSSETREPLICAINFO
SP_MSSETREPLICASTATUS
SP_MSSETROWMETADATA
SP_MSSETSERVERPROPERTIES
SP_MSSETSUBSCRIBERINFO
SP_MSSETTOPOLOGY
SP_MSSETUPBELONGS
SP_MSSETUPBELONGS_WITHOUTVIEWPROC
SP_MSSETUPNOTBELONGS
SP_MSSETUPWORKTABLES
SP_MSSHAREDFIXEDDISK
SP_MSSQLDMO70_VERSION
SP_MSSQLDMO80_VERSION
SP_MSSQLOLE_VERSION
SP_MSSQLOLE65_VERSION
SP_MSSUB_CHECK_IDENTITY
SP_MSSUB_CLEANUP_ORPHANS
SP_MSSUB_CLEANUP_PROP_TABLE
SP_MSSUB_SET_IDENTITY
SP_MSSUBSCRIPTION_ENABLED_FOR_SYNCMGR
SP_MSSUBSCRIPTIONVALIDATED
SP_MSSUBSETPUBLICATION
SP_MSSUBST_FILTER_NAME
SP_MSSUBST_FILTER_NAMES
SP_MSTABLE_HAS_UNIQUE_INDEX
SP_MSTABLE_NOT_MODIFIABLE
SP_MSTABLECHECKS
SP_MSTABLEKEYS
SP_MSTABLENAMEFROMNICK
SP_MSTABLENICKNAME
SP_MSTABLEREFS
SP_MSTABLESPACE
SP_MSTESTBIT
SP_MSUNC_TO_DRIVE
SP_MSUNIQUECOLNAME
SP_MSUNIQUENAME
SP_MSUNIQUEOBJECTNAME
SP_MSUNIQUETEMPNAME
SP_MSUNMARKIFNEEDED
SP_MSUNMARKREPLINFO
SP_MSUNMARKSCHEMAOBJECT
SP_MSUNREGISTERSUBSCRIPTION
SP_MSUPDATE_AGENTTYPE_DEFAULT
SP_MSUPDATE_REPLICATION_STATUS
SP_MSUPDATECONTENTS
SP_MSUPDATEGENHISTORY
SP_MSUPDATELASTSYNCINFO
SP_MSUPDATESCHEMACHANGE
SP_MSUPDATESHAREDAGENTPROPERTIES
SP_MSUPDATESYSMERGEARTICLES
SP_MSUPG_CREATECATALOGCOMPUTEDCOLS
SP_MSUPG_DOSYSTABCATALOGUPGRADES
SP_MSUPG_DROPCATALOGCOMPUTEDCOLS
SP_MSUPG_RECREATECATALOGFAKETABLES
SP_MSUPG_RECREATESYSTEMVIEWS
SP_MSUPG_REMOVESYSTEMCOMPUTEDCOLUMNS
SP_MSUPG_UPGRADECATALOG
SP_MSUPGRADECONFLICTTABLE
SP_MSUPLINEAGEVERSION
SP_MSVALIDATE_AGENT_PARAMETER
SP_MSVALIDATE_SUBSCRIPTION
SP_MSVALIDATEARTICLE
SP_MSVERIFYTRANFILTER
SP_OACREATE
SP_OADESTROY
SP_OAGETERRORINFO
SP_OAGETPROPERTY
SP_OAMETHOD
SP_OASETPROPERTY
SP_OASTOP
SP_OBJECTFILEGROUP
SP_OLEDB_COLUMN_CONSTRAINTS
SP_OLEDB_DATABASE
SP_OLEDB_DEFDB
SP_OLEDB_DEFLANG
SP_OLEDB_INDEXINFO
SP_OLEDB_LANGUAGE
SP_OLEDB_RO_USRNAME
SP_OLEDBINFO
SP_PASSWORD
SP_PKEYS
SP_PREPARE
SP_PREPEXEC
SP_PREPEXECRPC
SP_PRIMARY_KEYS_ROWSET
SP_PRIMARYKEYS
SP_PROCEDURE_PARAMS_ROWSET
SP_PROCEDURES_ROWSET
SP_PROCESSMAIL
SP_PROCOPTION
SP_PROP_OLEDB_PROVIDER
SP_PROVIDER_TYPES_ROWSET
SP_PUBLICATION_VALIDATION
SP_PUBLISHDB
SP_READERRORLOG
SP_READWEBTASK
SP_RECOMPILE
SP_REFRESHSUBSCRIPTIONS
SP_REFRESHVIEW
SP_REINITMERGEPULLSUBSCRIPTION
SP_REINITMERGESUBSCRIPTION
SP_REINITPULLSUBSCRIPTION
SP_REINITSUBSCRIPTION
SP_RELEASEAPPLOCK
SP_RELEASESCHEMALOCK
SP_REMOTEOPTION
SP_REMOVE_TEMPDB_FILE
SP_REMOVEDBREPLICATION
SP_REMOVESRVREPLICATION
SP_RENAME
SP_RENAMEDB
SP_REPLADDCOLUMN
SP_REPLCMDS
SP_REPLCOUNTERS
SP_REPLDONE
SP_REPLDROPCOLUMN
SP_REPLFLUSH
SP_REPLICA
SP_REPLICATION_AGENT_CHECKUP
SP_REPLICATIONDBOPTION
SP_REPLICATIONOPTION
SP_REPLINCREMENTLSN
SP_REPLPOSTCMD
SP_REPLPOSTSCHEMA
SP_REPLPOSTSYNCSTATUS
SP_REPLPROBEREMOTESERVER
SP_REPLQUEUEMONITOR
SP_REPLRESTART
SP_REPLSENDTOQUEUE
SP_REPLSETORIGINATOR
SP_REPLSETSYNCSTATUS
SP_REPLSHOWCMDS
SP_REPLSQLQGETROWS
SP_REPLSYNC
SP_REPLTRANS
SP_REPLUPDATESCHEMA
SP_REPLWRITETOVARBIN
SP_RESET_CONNECTION
SP_RESETSTATUS
SP_RESOLVE_LOGINS
SP_RESTOREDBREPLICATION
SP_RESYNCEXECUTE
SP_RESYNCEXECUTESQL
SP_RESYNCMERGESUBSCRIPTION
SP_RESYNCPREPARE
SP_RESYNCUNIQUETABLE
SP_REVOKE_PUBLICATION_ACCESS
SP_REVOKEDBACCESS
SP_REVOKELOGIN
SP_RUNWEBTASK
SP_SCHEMATA_ROWSET
SP_SCRIPT_RECONCILIATION_DELPROC
SP_SCRIPT_RECONCILIATION_INSPROC
SP_SCRIPT_RECONCILIATION_XDELPROC
SP_SCRIPT_SYNCTRAN_COMMANDS
SP_SCRIPTDELPROC
SP_SCRIPTINSPROC
SP_SCRIPTMAPPEDUPDPROC
SP_SCRIPTPKWHERECLAUSE
SP_SCRIPTRECONWHERECLAUSE
SP_SCRIPTSUBCONFLICTTABLE
SP_SCRIPTUPDATEPARAMS
SP_SCRIPTUPDPROC
SP_SCRIPTXDELPROC
SP_SCRIPTXUPDPROC
SP_SDIDEBUG
SP_SERVER_INFO
SP_SERVEROPTION
SP_SETAPPROLE
SP_SETNETNAME
SP_SETREPLFAILOVERMODE
SP_SETTRIGGERORDER
SP_SHOWROWREPLICAINFO
SP_SPACEUSED
SP_SPECIAL_COLUMNS
SP_SPROC_COLUMNS
SP_SQLEXEC
SP_SRVROLEPERMISSION
SP_STATISTICS
SP_STATISTICS_ROWSET
SP_STORED_PROCEDURES
SP_SUBSCRIBE
SP_SUBSCRIPTION_CLEANUP
SP_TABLE_CONSTRAINTS_ROWSET
SP_TABLE_PRIVILEGES
SP_TABLE_PRIVILEGES_EX
SP_TABLE_PRIVILEGES_ROWSET
SP_TABLE_STATISTICS_ROWSET
SP_TABLE_VALIDATION
SP_TABLECOLLATIONS
SP_TABLEOPTION
SP_TABLES
SP_TABLES_EX
SP_TABLES_INFO_ROWSET
SP_TABLES_ROWSET
SP_TABLESWC
SP_TEMPDBSPACE
SP_TRACE_CREATE
SP_TRACE_GENERATEEVENT
SP_TRACE_GETDATA
SP_TRACE_SETEVENT
SP_TRACE_SETFILTER
SP_TRACE_SETSTATUS
SP_UNBINDEFAULT
SP_UNBINDRULE
SP_UNPREPARE
SP_UNSUBSCRIBE
SP_UPDATEEXTENDEDPROPERTY
SP_UPDATESTATS
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_VALIDATELOGINS
SP_VALIDATEMERGEPUBLICATION
SP_VALIDATEMERGEPULLSUBSCRIPTION
SP_VALIDATEMERGESUBSCRIPTION
SP_VALIDATEPROPERTYINPUTS
SP_VALIDLANG
SP_VALIDNAME
SP_VERIFY_PUBLICATION
SP_VUPGRADE_DISTDB
SP_VUPGRADE_MERGETABLES
SP_VUPGRADE_MSSUBSCRIPTION_PROPERTIES
SP_VUPGRADE_PUBLISHER
SP_VUPGRADE_PUBLISHERDB
SP_VUPGRADE_REGISTRY
SP_VUPGRADE_REPLICATION
SP_VUPGRADE_REPLMSDB
SP_VUPGRADE_SUBPASS
SP_VUPGRADE_SUBSCRIPTION_DATABASES
SP_VUPGRADE_SUBSCRIPTION_TABLES
SP_VUPGRADE_SYSCOL_STATUS
SP_WHO
SP_WHO2
SP_XML_PREPAREDOCUMENT
SP_XML_REMOVEDOCUMENT
XP_AVAILABLEMEDIA
XP_CLEANUPWEBTASK
XP_CMDSHELL
XP_CONTROLQUEUESERVICE
XP_CONVERTWEBTASK
XP_CREATEPRIVATEQUEUE
XP_CREATEQUEUE
XP_DECODEQUEUECMD
XP_DELETEMAIL
XP_DELETEPRIVATEQUEUE
XP_DELETEQUEUE
XP_DIRTREE
XP_DISPLAYPARAMSTMT
XP_DISPLAYQUEUEMESGS
XP_DROPWEBTASK
XP_DSNINFO
XP_ENUM_ACTIVESCRIPTENGINES
XP_ENUM_OLEDB_PROVIDERS
XP_ENUMCODEPAGES
XP_ENUMDSN
XP_ENUMERRORLOGS
XP_ENUMGROUPS
XP_EVENTLOG
XP_EXECRESULTSET
XP_FILEEXIST
XP_FINDNEXTMSG
XP_FIXEDDRIVES
XP_GET_MAPI_DEFAULT_PROFILE
XP_GET_MAPI_PROFILES
XP_GET_TAPE_DEVICES
XP_GETFILEDETAILS
XP_GETNETNAME
XP_GETPROTOCOLDLLINFO
XP_GRANTLOGIN
XP_INITCOLVS
XP_INSTANCE_REGADDMULTISTRING
XP_INSTANCE_REGDELETEKEY
XP_INSTANCE_REGDELETEVALUE
XP_INSTANCE_REGENUMKEYS
XP_INSTANCE_REGENUMVALUES
XP_INSTANCE_REGREAD
XP_INSTANCE_REGREMOVEMULTISTRING
XP_INSTANCE_REGWRITE
XP_INTERSECTBITMAPS
XP_ISNTADMIN
XP_LOGEVENT
XP_LOGINCONFIG
XP_LOGININFO
XP_MAKECAB
XP_MAKEWEBTASK
XP_MAPDOWN_BITMAP
XP_MERGELINEAGES
XP_MERGEXPUSAGE
XP_MSADENABLED
XP_MSADSIOBJREG
XP_MSADSIOBJREGDB
XP_MSADSIREG
XP_MSFULLTEXT
XP_MSLOCALSYSTEM
XP_MSNT2000
XP_MSPLATFORM
XP_MSVER
XP_MSX_ENLIST
XP_NTSEC_ENUMDOMAINS
XP_OLEDBINFO
XP_ORBITMAP
XP_PEEKQUEUE
XP_PRINTSTATEMENTS
XP_PROP_OLEDB_PROVIDER
XP_PROXIEDMETADATA
XP_QV
XP_READERRORLOG
XP_READMAIL
XP_READPKFROMQUEUE
XP_READPKFROMVARBIN
XP_READWEBTASK
XP_REGADDMULTISTRING
XP_REGDELETEKEY
XP_REGDELETEVALUE
XP_REGENUMKEYS
XP_REGENUMVALUES
XP_REGREAD
XP_REGREMOVEMULTISTRING
XP_REGWRITE
XP_REPL_CONVERT_ENCRYPT
XP_REPL_ENCRYPT
XP_REPL_HELP_CONNECT
XP_REPLPROBEREMSRV
XP_RESETQUEUE
XP_REVOKELOGIN
XP_RUNWEBTASK
XP_SENDMAIL
XP_SERVICECONTROL
XP_SETSQLSECURITY
XP_SHOWCOLV
XP_SHOWLINEAGE
XP_SPRINTF
XP_SQLAGENT_ENUM_JOBS
XP_SQLAGENT_IS_STARTING
XP_SQLAGENT_MONITOR
XP_SQLAGENT_NOTIFY
XP_SQLAGENT_PARAM
XP_SQLAGENT_PROXY_ACCOUNT
XP_SQLMAINT
XP_SSCANF
XP_STARTMAIL
XP_STOPMAIL
XP_SUBDIRS
XP_TERMINATE_PROCESS
XP_TEST_MAPI_PROFILE
XP_UNC_TO_DRIVE
XP_UNPACKCAB
XP_UPDATECOLVBM
XP_UPDATEFTSSQLACCOUNT
XP_UPDATELINEAGE
XP_USERLOCK
XP_VARBINTOHEXSTR

[Keywords 4]

@@CONNECTIONS
@@CPU_BUSY
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@FETCH_STATUS
@@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
ABS
ACOS
APP_NAME
ASCII
ASIN
ATAN
ATN2
AVG
BINARY_CHECKSUM
CASE
CAST
CEILING
CHARINDEX
CHECKSUM
CHECKSUM_AGG
COALESCE
COL_LENGTH
COL_NAME
COLLATIONPROPERTY
COLUMNPROPERTY
CONVERT
COS
COT
COUNT
COUNT_BIG
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR_STATUS
DATABASEPROPERTY
DATABASEPROPERTYEX
DATALENGTH
DATEADD
DATEDIFF
DATENAME
DATEPART
DAY
DB_ID
DB_NAME
DEGREES
DIFFERENCE
EXP
FILE_ID
FILE_NAME
FILEGROUP_ID
FILEGROUP_NAME
FILEGROUPPROPERTY
FILEPROPERTY
FLOOR
FORMATMESSAGE
FULLTEXTCATALOGPROPERTY
FULLTEXTSERVICEPROPERTY
GETANSINULL
GETDATE
GETUTCDATE
HOST_ID
HOST_NAME
IDENT_CURRENT
IDENT_INCR
IDENT_SEED
INDEX_COL
INDEXKEY_PROPERTY
INDEXPROPERTY
IS_MEMBER
IS_SRVROLEMEMBER
ISDATE
ISNULL
ISNUMERIC
LEFT
LEN
LOG
LOG10
LOWER
LTRIM
MAX
MIN
MONTH
NEWID
NULLIF
OBJECT_ID
OBJECT_NAME
OBJECTPROPERTY
PARSENAME
PATINDEX
PERMISSIONS
PI
POWER
QUOTENAME
RADIANS
RAND
REPLACE
REPLICATE
REVERSE
RIGHT
ROUND
RTRIM
SCOPE_IDENTITY
SERVERPROPERTY
SESSION_USER
SESSIONPROPERTY
SIGN
SIN
SOUNDEX
SPACE
SQL_VARIANT_PROPERTY
SQRT
SQUARE
STATS_DATE
STDEV
STDEVP
STR
STUFF
SUBSTRING
SUM
SUSER_ID
SUSER_NAME
SUSER_SID
SUSER_SNAME
SYSTEM_USER
TAN
TEXTPTR
TEXTVALID
TYPE_NAME
TYPEPROPERTY
UNICODE
UPPER
USER
USER_ID
USER_NAME
VAR
VARP
YEAR


[Keywords 5]
&SQL_version
&SQL7
&SQL65
&SQL2000
&SQL60

[Preprocessor Keywords]
$IF
$IFDEF
$ELSEIF
$ELSEDEF
$ELSE
$ENDIF
$MACRO
$MACRO_LONG
$ENDMACRO
$UNDEF
$TABLE
$INCLUDE
$REQUIRE
$USEDBY





--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
From: David Gugick on
Erland Sommarskog wrote:
> David Gugick (davidg-nospam(a)imceda.com) writes:
>> Big TextPad fan as well. Just curious what SQL syntax file you're
>> using with TextPad.
>
> It's one that I got off the Textpad site several years ago. I've since
> augmented it for SQL 2000. I've included the file below.
>
Thanks. I'll see how it compares to the one I have installed.

--
David Gugick
Imceda Software
www.imceda.com

From: mark baekdal on
check out DB Ghost (http://www.dbghost.com) for a solution to database change
management using source control.

"Sam" wrote:

> Has anybody used VSS with sql server to control the code changes of sql
> server objects?
>
> what is the best way to setup and use it?
> please advice .
>
> thank you
> sam
>
>
>