C:\SQL.LOG File, And growing very large

We have a Micrsoft SQL Server 7.0, running on Windows 2000 Server SP 4. The
problem is while the SQL service is running it will create a file,
C:\SQL.LOG and it will grow very large. Over a 5 minute period it was about
1.5 M. As you can imagine, it doesn't take long for this file to grow into
Gigs. Any idea what is causing this file? here are some of the contents:
sqlagent 31c-4bc ENTER SQLAllocEnv
HENV * 410F6438
sqlagent 31c-4bc EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x410F6438 ( 0x00581540)
sqlagent 31c-81c ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 00CDE1D8
sqlagent 31c-81c EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0x00CDE1D8 ( 0x005815e8)
sqlagent 31c-81c ENTER SQLSetEnvAttr
SQLHENV 005815E8
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003
SQLINTEGER -5
sqlagent 31c-81c EXIT SQLSetEnvAttr with return code 0
(SQL_SUCCESS)
SQLHENV 005815E8
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5
sqlagent 31c-81c ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 005815E8
SQLHANDLE * 00CDE1DC
sqlagent 31c-81c EXIT SQLAllocHandle with return code 0
(SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 005815E8
SQLHANDLE * 0x00CDE1DC ( 0x00581690)
sqlagent 31c-81c ENTER SQLSetConnectAttrW
SQLHDBC 00581690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000001E
SQLINTEGER -5
sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00581690
SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
SQLPOINTER 0x0000001E (BADMEM)
SQLINTEGER -5
sqlagent 31c-81c ENTER SQLSetConnectAttrW
SQLHDBC 00581690
SQLINTEGER 1217 <unknown>
SQLPOINTER [Unknown attribute 1217]
SQLINTEGER -5
sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00581690
SQLINTEGER 1217 <unknown>
SQLPOINTER [Unknown attribute 1217]
SQLINTEGER -5
sqlagent 31c-81c ENTER SQLSetConnectAttrW
SQLHDBC 00581690
SQLINTEGER 112 <SQL_ATTR_PACKET_SIZE>
SQLPOINTER 0x00000000
SQLINTEGER -5
sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00581690
SQLINTEGER 112 <SQL_ATTR_PACKET_SIZE>
SQLPOINTER 0x00000000
SQLINTEGER -5
sqlagent 31c-81c ENTER SQLSetConnectAttrW
SQLHDBC 00581690
SQLINTEGER 1203 <unknown>
SQLPOINTER [Unknown attribute 1203]
SQLINTEGER -5
sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
(SQL_SUCCESS)
SQLHDBC 00581690
SQLINTEGER 1203 <unknown>
SQLPOINTER [Unknown attribute 1203]
SQLINTEGER -5
sqlagent 31c-81c ENTER SQLDriverConnectW
HDBC 00581690
HWND 00000000
WCHAR * 0x1F7C48DC [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C48DC
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
sqlagent 31c-81c EXIT SQLDriverConnectW with return code 1
(SQL_SUCCESS_WITH_INFO)
HDBC 00581690
HWND 00000000
WCHAR * 0x1F7C48DC [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1F7C48DC
SWORD 8
SWORD * 0x00000000
UWORD 0 <SQL_DRIVER_NOPROMPT>
DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
database context to 'msdb'. (5701)
DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
language setting to us_english. (5703)
There's more, but I'll spare you.
Ryan
Woops, sorry, forgot I turned on ODBC tracing. It was on the Tracing tab on
odbcad32
I turned it off and it went away.
"Ryan McAtee" <rmcatee_fwd@.verizon.net> wrote in message
news:%23TH%23KphGHHA.4688@.TK2MSFTNGP04.phx.gbl...
> We have a Micrsoft SQL Server 7.0, running on Windows 2000 Server SP 4.
> The problem is while the SQL service is running it will create a file,
> C:\SQL.LOG and it will grow very large. Over a 5 minute period it was
> about 1.5 M. As you can imagine, it doesn't take long for this file to
> grow into Gigs. Any idea what is causing this file? here are some of the
> contents:
>
> sqlagent 31c-4bc ENTER SQLAllocEnv
> HENV * 410F6438
> sqlagent 31c-4bc EXIT SQLAllocEnv with return code 0
> (SQL_SUCCESS)
> HENV * 0x410F6438 ( 0x00581540)
> sqlagent 31c-81c ENTER SQLAllocHandle
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 00CDE1D8
> sqlagent 31c-81c EXIT SQLAllocHandle with return code 0
> (SQL_SUCCESS)
> SQLSMALLINT 1 <SQL_HANDLE_ENV>
> SQLHANDLE 00000000
> SQLHANDLE * 0x00CDE1D8 ( 0x005815e8)
> sqlagent 31c-81c ENTER SQLSetEnvAttr
> SQLHENV 005815E8
> SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
> SQLPOINTER 0x00000003
> SQLINTEGER -5
> sqlagent 31c-81c EXIT SQLSetEnvAttr with return code 0
> (SQL_SUCCESS)
> SQLHENV 005815E8
> SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
> SQLPOINTER 0x00000003 (BADMEM)
> SQLINTEGER -5
> sqlagent 31c-81c ENTER SQLAllocHandle
> SQLSMALLINT 2 <SQL_HANDLE_DBC>
> SQLHANDLE 005815E8
> SQLHANDLE * 00CDE1DC
> sqlagent 31c-81c EXIT SQLAllocHandle with return code 0
> (SQL_SUCCESS)
> SQLSMALLINT 2 <SQL_HANDLE_DBC>
> SQLHANDLE 005815E8
> SQLHANDLE * 0x00CDE1DC ( 0x00581690)
> sqlagent 31c-81c ENTER SQLSetConnectAttrW
> SQLHDBC 00581690
> SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
> SQLPOINTER 0x0000001E
> SQLINTEGER -5
> sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
> (SQL_SUCCESS)
> SQLHDBC 00581690
> SQLINTEGER 103 <SQL_ATTR_LOGIN_TIMEOUT>
> SQLPOINTER 0x0000001E (BADMEM)
> SQLINTEGER -5
> sqlagent 31c-81c ENTER SQLSetConnectAttrW
> SQLHDBC 00581690
> SQLINTEGER 1217 <unknown>
> SQLPOINTER [Unknown attribute 1217]
> SQLINTEGER -5
> sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
> (SQL_SUCCESS)
> SQLHDBC 00581690
> SQLINTEGER 1217 <unknown>
> SQLPOINTER [Unknown attribute 1217]
> SQLINTEGER -5
> sqlagent 31c-81c ENTER SQLSetConnectAttrW
> SQLHDBC 00581690
> SQLINTEGER 112 <SQL_ATTR_PACKET_SIZE>
> SQLPOINTER 0x00000000
> SQLINTEGER -5
> sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
> (SQL_SUCCESS)
> SQLHDBC 00581690
> SQLINTEGER 112 <SQL_ATTR_PACKET_SIZE>
> SQLPOINTER 0x00000000
> SQLINTEGER -5
> sqlagent 31c-81c ENTER SQLSetConnectAttrW
> SQLHDBC 00581690
> SQLINTEGER 1203 <unknown>
> SQLPOINTER [Unknown attribute 1203]
> SQLINTEGER -5
> sqlagent 31c-81c EXIT SQLSetConnectAttrW with return code 0
> (SQL_SUCCESS)
> SQLHDBC 00581690
> SQLINTEGER 1203 <unknown>
> SQLPOINTER [Unknown attribute 1203]
> SQLINTEGER -5
> sqlagent 31c-81c ENTER SQLDriverConnectW
> HDBC 00581690
> HWND 00000000
> WCHAR * 0x1F7C48DC [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x1F7C48DC
> SWORD 8
> SWORD * 0x00000000
> UWORD 0 <SQL_DRIVER_NOPROMPT>
> sqlagent 31c-81c EXIT SQLDriverConnectW with return code 1
> (SQL_SUCCESS_WITH_INFO)
> HDBC 00581690
> HWND 00000000
> WCHAR * 0x1F7C48DC [ -3] "******\ 0"
> SWORD -3
> WCHAR * 0x1F7C48DC
> SWORD 8
> SWORD * 0x00000000
> UWORD 0 <SQL_DRIVER_NOPROMPT>
> DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
> database context to 'msdb'. (5701)
> DIAG [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed
> language setting to us_english. (5703)
>
> There's more, but I'll spare you.
> Ryan
>