# Define SciTE settings for MSSQL files. filter.mssql=SQL (sql)|*.sql| file.patterns.mssql=*.sql lexer.$(file.patterns.mssql)=mssql #Default style.mssql.0=$(font.base),$(colour.base) # Comment style.mssql.1=$(font.comment),$(colour.code.comment.box) # Line Comment style.mssql.2=$(font.comment),$(colour.code.comment.line) # Number style.mssql.3=$(colour.number) # String style.mssql.4=$(colour.string) # Operator style.mssql.5=$(font.base),bold # Identifier style.mssql.6=$(font.base) # Variable style.mssql.7=$(colour.variable) # Column name style.mssql.8=fore:#008400 # Statement style.mssql.9=$(colour.keyword),bold #~ style.mssql.9=fore:#0000FF,bold,case:u # Data type style.mssql.10=fore:#EC9F00 #~ style.mssql.10=fore:#FFAD00 # System table style.mssql.11=fore:#10AD10,italics # Global variable style.mssql.12=fore:#B300B3 # Function style.mssql.13=fore:#FF66CC # Stored procedure style.mssql.14=fore:#AF0000 # Default pref. datatype style.mssql.15=fore:#0000FF # Object name marked with [] style.mssql.16=fore:#008400 comment.block.mssql=-- comment.block.at.line.start.mssql=1 comment.stream.start.mssql=/* comment.stream.end.mssql=*/ comment.box.start.mssql=/* comment.box.middle.mssql=* comment.box.end.mssql=*/ # Statements keywords.$(file.patterns.mssql)=\ action add all alter and any as asc authorization \ backup begin between break browse bulk by \ cascade case check checkpoint close clustered coalesce collate column commit committed compute confirm constraint contains containstable \ continue controlrow convert create cross current current_date current_time current_timestamp current_user cursor \ database dbcc deallocate declare default delete deny desc disable disk distinct distributed double drop dummy dump \ else enable end errlvl errorexit escape except exec execute exists exit \ fetch file fillfactor floppy for foreign forward_only freetext freetexttable from full function \ go goto grant group \ having holdlock \ identity identity_insert identitycol if in index inner insert instead intersect into is isolation \ join \ key kill \ left level like lineno load \ mirrorexit move \ national no nocheck nocount nonclustered norecovery not nounload null nullif \ of off offsets on once only open opendatasource openquery openrowset option or order outer output over \ percent perm permanent pipe plan precision prepare primary print privileges proc procedure processexit public \ raiserror read readtext read_only reconfigure recovery references repeatable replication restore restrict return returns revoke right rollback rowcount rowguidcol rule \ save schema select serializable session_user set setuser shutdown some statistics stats system_user \ table tape temp temporary textsize then to top tran transaction trigger truncate tsequal \ uncommitted union unique update updatetext use user \ values varying view \ waitfor when where while with work writetext # Data types keywords2.$(file.patterns.mssql)=\ bigint binary bit \ char character \ datetime dec decimal \ float \ image int integer \ money \ nchar ntext numeric nvarchar \ real \ smalldatetime smallint smallmoney sql_variant sysname \ text timestamp tinyint \ uniqueidentifier \ varbinary varchar # System tables keywords3.$(file.patterns.mssql)=\ deleted \ inserted \ sysallocations sysalternates sysaltfiles syscacheobjects syscharsets syscolumns syscomments sysconfigures sysconstraints syscurconfigs syscursorcolumns syscursorrefs \ syscursors syscursortables sysdatabases sysdepends sysdevices sysfilegroups sysfiles sysfiles1 sysforeignkeys sysfulltextcatalogs sysindexes sysindexkeys syslanguages \ syslockinfo syslocks syslogins sysmembers sysmessages sysobjects sysoledbusers sysperfinfo syspermissions sysprocesses sysprotects sysreferences \ sysremote_catalogs sysremote_column_privileges sysremote_columns \ sysremote_foreign_keys \ sysremote_indexes \ sysremote_primary_keys sysremote_provider_types \ sysremote_schemata sysremote_statistics \ sysremote_table_privileges sysremote_tables sysremote_views \ sysremotelogins \ syssegments \ sysservers \ systypes \ sysusers \ sysxlogins # Global variables keywords4.$(file.patterns.mssql)=\ 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 timetickstotal_errors total_read total_write trancount version # Functions keywords5.$(file.patterns.mssql)=\ abs acos app_name ascii asin atan atn2 avg \ binary_checksum \ case cast ceiling char charindex checksum checksum_agg \ coalesce collationproperty col_length col_name columns_updated 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 \ fn_dblog fn_escapecmdshellsymbols fn_escapecmdshellsymbolsremovequotes fn_generateparameterpattern fn_get_sql fn_getpersistedservernamecasevariation \ fn_helpcollations fn_chariswhitespace fn_isreplmergeagent fn_listextendedproperty fn_msfulltext fn_msgensqescstr fn_mssharedversion \ fn_removeparameterwithargument fn_repladjustcolumnmap fn_replbitstringtoint fn_replcomposepublicationsnapshotfolder \ fn_replgenerateshorterfilenameprefix fn_replgetagentcommandlinefromjobid fn_replgetbinary8lodword fn_replinttobitstring fn_replmakestringliteral \ fn_replprepadbinary8 fn_replquotename fn_replrotr fn_repltrimleadingzerosinhexstr 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 \ formatmessage fulltextcatalogproperty fulltextserviceproperty \ getansinull getdate getutcdate grouping \ has_dbaccess 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 \ nchar newid nullif \ object_id object_name objectproperty \ parsename patindex permissions pi power \ quotename \ radians rand replace replicate reverse right round rowcount_big rtrim \ scope_identity serverproperty sessionproperty session_user sign sin soundex space sqare sql_variant_property \ sqrt stats_date stdev stdevp str stuff substring sum suser_sid suser_sname system_user \ tan typeproperty \ unicode upper user_id user_name \ var varp \ year # System stored procedures keywords6.$(file.patterns.mssql)=\ 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_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_createmergepalrole 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_execresultset 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_getqueuedarticlesynctraninfo sp_getqueuedrows \ sp_getschemalock sp_getsqlqueueversion 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_help_revlogin 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_helpmergecleanupwait 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_hexadecimal 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_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_mergecompletecleanup \ sp_mergedummyupdate sp_mergemetadataretentioncleanup sp_mergepreparecleanup 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_mscleanup_conflict sp_mscleanup_conflict_table sp_mscleanup_metadata sp_mscleanup_publication_adinfo \ sp_mscleanup_zeroartnick_genhistory sp_mscleanupdynsnapshotvws sp_mscleanupforpullreinit sp_mscleanupmergepublisher \ sp_mscleanupmergepublisherdb sp_mscleanuptask sp_msclearcolumnbit sp_mscompletecleanup 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_mscreatedupkeyupdatequery sp_mscreateglobalreplica sp_mscreateretry sp_msdbuseraccess sp_msdbuserpriv sp_msdefer_check \ sp_msdelete_specifiedcontents 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_msenumcolumns \ sp_msenumdeletesmetadata sp_msenumgenerations sp_msenumchanges sp_msenummergepublications sp_msenumpartialdeletes sp_msenumpartialchanges \ sp_msenumpubreferences sp_msenumreplicas sp_msenumretries sp_msenumschemachange sp_msenumschemachange_70 sp_msenumschemachange_80 \ sp_msenumschemachange_80sp3 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_msfixupbeforeimagetables \ 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_msgetcolordinalfromcolname sp_msgetcolumnlist \ sp_msgetconflictinsertproc sp_msgetconflicttablename sp_msgetchangecount sp_msgetlastrecgen sp_msgetlastsentgen sp_msgetlastsentrecgens \ sp_msgetlastupdatedtime sp_msgetmakegenerationapplock 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_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_mschunkgeneration 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_msisnonpkukupdateinconflict sp_msispkupdateinconflict \ sp_msispulldistributionjobnamegenerated sp_msispullmergejobnamegenerated 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_mspreparecleanup sp_mspropagateschematorepubs sp_msproxiedmetadata sp_mspub_adjust_identity sp_mspublicationcleanup sp_mspublicationview \ sp_mspublishdb sp_mspurgecontentsorphans sp_msquerysubtype sp_msquiesceforcleanup sp_msquiescecheck sp_msquiescetriggersoff \ sp_msquiescetriggerson sp_msreenable_check sp_msrefcnt sp_msregistersubscription sp_msreinit_article sp_msreinit_failed_subscriptions \ sp_msreinit_hub sp_msreinitmergepublication sp_msreleasemakegenerationapplock 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_dbrole sp_msrepl_droprolemember sp_msrepl_fixpalrole sp_msrepl_gettype_mappings sp_msrepl_check_server \ sp_msrepl_isdbowner sp_msrepl_linkedservers_rowset sp_msrepl_pal_rolecheck 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_msscriptdelconflictfinder sp_msscriptinsertconflictfinder sp_msscriptmvastable sp_msscriptmvastableidx \ sp_msscriptmvastablenci sp_msscriptmvastablepkc sp_msscriptupdateconflictfinder sp_msscriptviewproc 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_mssethighestversion \ 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_cleanup_orphans \ sp_mssub_cleanup_prop_table sp_mssub_check_identity 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_mqserver_distdb sp_msupdate_mqserver_subdb \ sp_msupdate_replication_status sp_msupdatecontents sp_msupdategenhistory sp_msupdatelastsyncinfo sp_msupdatesharedagentproperties \ sp_msupdateschemachange 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_populateqtraninfo 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_repldeletequeuedtran sp_repldone sp_repldropcolumn sp_replflush sp_replica \ sp_replication_agent_checkup sp_replicationdboption sp_replicationoption sp_replincrementlsn sp_replincrementlsn_internal sp_replpostcmd \ sp_replpostschema sp_replpostsyncstatus sp_replpostsyncstatus_int sp_replproberemoteserver sp_replqueuemonitor sp_replrestart \ sp_replscriptuniquekeywhereclause sp_replsendtoqueue sp_replsetoriginator sp_replsetoriginator_internal sp_replsetoriginator_pal \ sp_replsetsyncstatus sp_replshowcmds sp_replsqlqgetrows sp_replsync sp_repltablehasnonpkuniquekey 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_script_insertforcftresolution sp_script_reconciliation_delproc sp_script_reconciliation_insproc sp_script_reconciliation_xdelproc \ sp_script_synctran_commands sp_scriptdelproc sp_scriptdynamicupdproc sp_scriptinsproc sp_scriptmappedupdproc sp_scriptpkwhereclause \ sp_scriptpublicationcustomprocs sp_scriptpubwinsrefreshcursorvars 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_setuserbylogin sp_showrowreplicainfo sp_schemata_rowset 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_adsirequest xp_availablemedia xp_cleanupwebtask xp_cmdshell xp_controlqueueservice xp_convertwebtask \ xp_createprivatequeue xp_decodequeuecmd xp_deletemail xp_deleteprivatequeue 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_getadmingroupname xp_getfiledetails xp_getnetname xp_getprotocoldllinfo xp_grantlogin 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_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_msx_account xp_sqlagent_notify xp_sqlagent_param xp_sqlagent_proxy_account xp_sqlmaint xp_sscanf xp_startmail \ xp_stopmail xp_subdirs xp_test_mapi_profile xp_unc_to_drive xp_unpackcab xp_updateftssqlaccount xp_userlock xp_varbintohexstr