|
|
|
|
|
|
| sp_dbcc_alterws
sp_dbcc_configreport sp_dbcc_createws sp_dbcc_deletedb sp_dbcc_deletehistory sp_dbcc_differentialreport sp_dbcc_evaluatedb sp_dbcc_faultreport sp_dbcc_fullreport sp_dbcc_runcheck sp_dbcc_statisticsreport sp_dbcc_summaryreport sp_dbcc_updateconfig |
xp_cmdshell
xp_deletemail xp_enumgroups xp_findnextmsg xp_logevent xp_readmail xp_sendmail xp_startmail xp_stopmail |
sp_activeroles
sp_add_resource_limit sp_add_time_range sp_addalias sp_addauditrecord sp_addaudittable sp_addengine sp_addexeclass sp_addextendedproc sp_addexternlogin sp_addgroup sp_addlanguage sp_addlogin sp_addmessage sp_addobjectdef sp_addremotelogin sp_addsegment sp_addserver sp_addthreshold sp_addtype sp_addumpdevice sp_adduser sp_altermessage sp_audit sp_autoconnect sp_bindcache sp_bindefault sp_bindexeclass sp_bindmsg sp_bindrule sp_cacheconfig sp_cachestrategy sp_changedbowner sp_changegroup sp_checknames sp_checkreswords sp_checksource sp_chgattribute sp_clearpsexe sp_clearstats sp_column_privileges sp_columns sp_commonkey sp_configure sp_countmetadata sp_cursorinfo sp_databases sp_datatype_info sp_dboption sp_dbrecovery_order sp_dbremap sp_defaultloc sp_depends sp_diskdefault sp_displayaudit sp_displaylevel sp_displaylogin sp_displayroles sp_drop_resource_limit sp_drop_time_range sp_dropalias sp_dropdevice sp_dropengine sp_dropexeclass sp_dropextendedproc sp_dropexternlogin sp_dropglockpromote sp_dropgroup sp_dropkey sp_droplanguage sp_droplogin sp_dropmessage sp_dropobjectdef sp_dropremotelogin sp_droprowlockpromote sp_dropsegment sp_dropserver sp_dropthreshold sp_droptype sp_dropuser sp_estspace sp_extendsegment sp_familylock sp_fkeys sp_flushstats sp_forceonline_db sp_forceonline_object sp_forceonline_page sp_foreignkey sp_freedll sp_getmessage sp_grantlogin sp_help sp_help_resource_limit sp_helpartition sp_helpcache sp_helpconfig sp_helpconstraint sp_helpdb sp_helpdevice sp_helpextendedproc sp_helpexternlogin sp_helpgroup sp_helpindex sp_helpjoins sp_helpkey sp_helplanguage sp_helplog sp_helpobjectdef sp_helpremotelogin sp_helprotect sp_helpsegment sp_helpserver sp_helpsort sp_helptext sp_helpthreshold sp_helpuser sp_hidetext sp_indsuspect sp_listsuspect_db sp_listsuspect_object sp_listsuspect_page sp_lock sp_locklogin sp_logdevice sp_loginconfig sp_logininfo sp_logiosize sp_modify_resource_limit sp_modify_time_range sp_modifylogin sp_modifythreshold sp_monitor sp_monitorconfig sp_object_stats sp_passthru sp_password sp_pkeys sp_placeobject sp_plan_dbccdb sp_poolconfig sp_primarykey sp_processmail sp_procqmode sp_procxmode sp_recompile sp_remap sp_remoteoption sp_remotesql sp_rename sp_renamedb sp_reportstats sp_revokelogin sp_role sp_server_info sp_serveroption sp_setlangalias sp_setpglockpromote sp_setpsexe sp_setrowlockpromote sp_setsuspect_granularity sp_setsuspect_threshold sp_showcontrolinfo sp_showexeclass sp_showplan sp_showpsexe sp_spaceused sp_special_columns sp_sproc_columns sp_statistics sp_stored_procedures sp_syntax sp_sysmon sp_table_privileges sp_tables sp_thresholdaction sp_unbindcache sp_unbindcache_all sp_unbindefault sp_unbindexeclass sp_unbindmsg sp_unbindrule sp_volchanged sp_who |
abs
acos alter database alter role alter table ascii asin atan atn2 avg begin transaction begin...end break case ceiling char char_length charindex checkpoint close col_length col_name commit compare compute Clause connect to...disconnect continue convert cos cot count create database create default create existing table create index create procedure create proxy_table create role create rule create schema create table create trigger create view curunreservedpgs data_pgs datalength dateadd datediff datename datepart db_id db_name dbcc deallocate cursor declare declare cursor degrees delete delete statistics difference disk init disk mirror disk refit disk reinit disk remirror disk unmirror drop database drop default drop index drop procedure drop role drop rule drop table drop trigger drop view dump database dump transaction execute exp fetch floor getdate goto Label grant group by and having hextoint host_id host_name if...else index_col index_colorder insert inttohex is_sec_service_on isnull kill lct_admin load database load transaction lock table log log10 lower ltrim max min mut_excl_roles object_id object_name online database open order by Clause patindex pi power prepare transaction proc_role ptn_data_pgs radians raiserror rand readtext reconfigure reorg replicate reserved_pgs return reverse revoke right role_contain role_id role_name rollback rollback trigger round rowcnt rtrim save transaction select set setuser show_role show_sec_services shutdown sign sin sortkey soundex space sqrt str stuff substring sum suser_id suser_name tan textptr textvalid truncate table tsequal union Operator update update partition statistics update statistics upper use used_pgs user user_id user_name valid_name valid_user waitfor where Clause while writetext |
backupserver
bcp buildmaster dataserver defncopy dscp dsedit isql langinstall optdiag showserver sqlloc sqllocres sqlupgrade sqlupgraderes srvbuild srvbuildres startserver sybload sybsetup |