#88 Some SQL Server system functions not syntax highlighted

[Duncan Lock]

There are some MS SQL Server system functions which
are not highlighted by the QC syntax highlighter.

There are a few of these, so I have included a list of the
currently unsupported/unhighlighted ones which are
documented in Books Online.

It has to be said that Query Analyzer doesn't highlight all
of these either, but does support all but 2 of them.

Thanks!
Dunc

Here they are:
---------------------------%<-------------------------------

--Configuration Functions

@@DATEFIRST
@@OPTIONS
@@DBTS
@@REMSERVER
@@LANGID
@@SERVERNAME
@@LANGUAGE
@@SERVICENAME
@@LOCK_TIMEOUT
@@SPID
@@MAX_CONNECTIONS
@@TEXTSIZE
@@MAX_PRECISION
@@VERSION
@@NESTLEVEL

--Cursor Functions

@@CURSOR_ROWS
@@FETCH_STATUS

--Meta Data Functions

COL_LENGTH
fn_listextendedproperty
COL_NAME
FULLTEXTCATALOGPROPERTY
COLUMNPROPERTY
FULLTEXTSERVICEPROPERTY
DATABASEPROPERTY
INDEX_COL
DATABASEPROPERTYEX
INDEXKEY_PROPERTY
DB_ID
INDEXPROPERTY
DB_NAME
OBJECT_ID
FILE_ID
OBJECT_NAME
FILE_NAME
OBJECTPROPERTY
FILEGROUP_ID
@@PROCID
FILEGROUP_NAME
SQL_VARIANT_PROPERTY
FILEGROUPPROPERTY
TYPEPROPERTY
FILEPROPERTY

--Security Functions

fn_trace_geteventinfo
IS_SRVROLEMEMBER
fn_trace_getfilterinfo
SUSER_SID
fn_trace_getinfo
SUSER_SNAME
fn_trace_gettable
USER_ID
HAS_DBACCESS
IS_MEMBER

--System Functions

APP_NAME
COLLATIONPROPERTY
@@ERROR
fn_helpcollations
fn_servershareddrives
fn_virtualfilestats
FORMATMESSAGE
GETANSINULL
HOST_ID
HOST_NAME
IDENT_CURRENT
IDENT_INCR
IDENT_SEED
@@IDENTITY
ISDATE
ISNUMERIC
PARSENAME
PERMISSIONS
@@ROWCOUNT
ROWCOUNT_BIG
SCOPE_IDENTITY
SERVERPROPERTY
SESSIONPROPERTY
STATS_DATE
@@TRANCOUNT
USER_NAME

--System Statistical Functions

@@CONNECTIONS
@@PACK_RECEIVED
@@CPU_BUSY
@@PACK_SENT
fn_virtualfilestats
@@TIMETICKS
@@IDLE
@@TOTAL_ERRORS
@@IO_BUSY
@@TOTAL_READ
@@PACKET_ERRORS
@@TOTAL_WRITE

--Text and Image Functions

TEXTPTR
TEXTVALID

[Duncan Lock]

Logged In: YES
user_id=478685

Sorry should have mentioned, this is with version 4, btw.
Dunc.