| Rev 1 |
|
Rev 3 |
| Line 2... |
|
Line 2... |
/************************************************************************************* |
|
/************************************************************************************* |
* tsql.php |
|
* tsql.php |
* -------- |
|
* -------- |
* Author: Duncan Lock (dunc@dflock.co.uk) |
|
* Author: Duncan Lock (dunc@dflock.co.uk) |
* Copyright: (c) 2006 Duncan Lock (http://dflock.co.uk/), Nigel McNie (http://qbnz.com/highlighter) |
|
* Copyright: (c) 2006 Duncan Lock (http://dflock.co.uk/), Nigel McNie (http://qbnz.com/highlighter) |
* Release Version: 1.0.8.1 |
|
* Release Version: 1.0.8.3 |
* Date Started: 2005/11/22 |
|
* Date Started: 2005/11/22 |
* |
|
* |
* T-SQL language file for GeSHi. |
|
* T-SQL language file for GeSHi. |
* |
|
* |
* CHANGES |
|
* CHANGES |
| Line 133... |
|
Line 133... |
'@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY', |
|
'@@ROWCOUNT','ROWCOUNT_BIG','SCOPE_IDENTITY','SERVERPROPERTY','SESSIONPROPERTY', |
'STATS_DATE','@@TRANCOUNT','USER_NAME', |
|
'STATS_DATE','@@TRANCOUNT','USER_NAME', |
|
|
|
//System Statistical Functions |
|
//System Statistical Functions |
'@@CONNECTIONS','@@PACK_RECEIVED','@@CPU_BUSY','@@PACK_SENT', |
|
'@@CONNECTIONS','@@PACK_RECEIVED','@@CPU_BUSY','@@PACK_SENT', |
'fn_virtualfilestats','@@TIMETICKS','@@IDLE','@@TOTAL_ERRORS','@@IO_BUSY', |
|
'@@TIMETICKS','@@IDLE','@@TOTAL_ERRORS','@@IO_BUSY', |
'@@TOTAL_READ','@@PACKET_ERRORS','@@TOTAL_WRITE', |
|
'@@TOTAL_READ','@@PACKET_ERRORS','@@TOTAL_WRITE', |
|
|
|
//Text and Image Functions |
|
//Text and Image Functions |
'TEXTPTR','TEXTVALID', |
|
'TEXTPTR','TEXTVALID', |
|
|
|
| Line 167... |
|
Line 167... |
'sp_delete_maintenance_plan_job', 'sp_add_maintenance_plan_job', 'sp_help_maintenance_plan', |
|
'sp_delete_maintenance_plan_job', 'sp_add_maintenance_plan_job', 'sp_help_maintenance_plan', |
'sp_delete_maintenance_plan', |
|
'sp_delete_maintenance_plan', |
|
|
|
//Distributed Queries Procedures |
|
//Distributed Queries Procedures |
'sp_addlinkedserver', 'sp_indexes', 'sp_addlinkedsrvlogin', 'sp_linkedservers', 'sp_catalogs', |
|
'sp_addlinkedserver', 'sp_indexes', 'sp_addlinkedsrvlogin', 'sp_linkedservers', 'sp_catalogs', |
'sp_primarykeys', 'sp_column_privileges_ex', 'sp_serveroption', 'sp_columns_ex', |
|
'sp_primarykeys', 'sp_column_privileges_ex', 'sp_columns_ex', |
'sp_table_privileges_ex', 'sp_droplinkedsrvlogin', 'sp_tables_ex', 'sp_foreignkeys', |
|
'sp_table_privileges_ex', 'sp_tables_ex', 'sp_foreignkeys', |
|
|
|
//Full-Text Search Procedures |
|
//Full-Text Search Procedures |
'sp_fulltext_catalog', 'sp_help_fulltext_catalogs_cursor', 'sp_fulltext_column', |
|
'sp_fulltext_catalog', 'sp_help_fulltext_catalogs_cursor', 'sp_fulltext_column', |
'sp_help_fulltext_columns', 'sp_fulltext_database', 'sp_help_fulltext_columns_cursor', |
|
'sp_help_fulltext_columns', 'sp_fulltext_database', 'sp_help_fulltext_columns_cursor', |
'sp_fulltext_service', 'sp_help_fulltext_tables', 'sp_fulltext_table', |
|
'sp_fulltext_service', 'sp_help_fulltext_tables', 'sp_fulltext_table', |
| Line 234... |
|
Line 234... |
'sp_update_agent_profile', 'sp_dropsubscriber', 'sp_validatemergepublication', 'sp_dropsubscription', |
|
'sp_update_agent_profile', 'sp_dropsubscriber', 'sp_validatemergepublication', 'sp_dropsubscription', |
'sp_validatemergesubscription', 'sp_dsninfo', 'sp_vupgrade_replication', 'sp_dumpparamcmd', |
|
'sp_validatemergesubscription', 'sp_dsninfo', 'sp_vupgrade_replication', 'sp_dumpparamcmd', |
|
|
|
//Security Procedures |
|
//Security Procedures |
'sp_addalias', 'sp_droprolemember', 'sp_addapprole', 'sp_dropserver', 'sp_addgroup', 'sp_dropsrvrolemember', |
|
'sp_addalias', 'sp_droprolemember', 'sp_addapprole', 'sp_dropserver', 'sp_addgroup', 'sp_dropsrvrolemember', |
'sp_addlinkedsrvlogin', 'sp_dropuser', 'sp_addlogin', 'sp_grantdbaccess', 'sp_addremotelogin', |
|
'sp_dropuser', 'sp_addlogin', 'sp_grantdbaccess', 'sp_addremotelogin', |
'sp_grantlogin', 'sp_addrole', 'sp_helpdbfixedrole', 'sp_addrolemember', 'sp_helpgroup', |
|
'sp_grantlogin', 'sp_addrole', 'sp_helpdbfixedrole', 'sp_addrolemember', 'sp_helpgroup', |
'sp_addserver', 'sp_helplinkedsrvlogin', 'sp_addsrvrolemember', 'sp_helplogins', 'sp_adduser', |
|
'sp_addserver', 'sp_helplinkedsrvlogin', 'sp_addsrvrolemember', 'sp_helplogins', 'sp_adduser', |
'sp_helpntgroup', 'sp_approlepassword', 'sp_helpremotelogin', 'sp_changedbowner', 'sp_helprole', |
|
'sp_helpntgroup', 'sp_approlepassword', 'sp_helpremotelogin', 'sp_changedbowner', 'sp_helprole', |
'sp_changegroup', 'sp_helprolemember', 'sp_changeobjectowner', 'sp_helprotect', 'sp_change_users_login', |
|
'sp_changegroup', 'sp_helprolemember', 'sp_changeobjectowner', 'sp_helprotect', 'sp_change_users_login', |
'sp_helpsrvrole', 'sp_dbfixedrolepermission', 'sp_helpsrvrolemember', 'sp_defaultdb', 'sp_helpuser', |
|
'sp_helpsrvrole', 'sp_dbfixedrolepermission', 'sp_helpsrvrolemember', 'sp_defaultdb', 'sp_helpuser', |
