SQL.LOG 2

[CatPlus]

From sometime back, MS SQL2000 has been creating a log which keeps on growing by the minute. The only we I can delete this log is to stop SQLSERVERAGENT from SERVICES and exit MSSQLSERVER from the task bar

In addition, the hard drive is making a crunching noise which I first thought was the beginning of the hard drive going bad. Noise stops after MS-SQL2000 is stopped

Here is an example of the entries in the LOG

660-70c ENTER SQLAllocHandle
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 01B671D4

660-70c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 <SQL_HANDLE_ENV>
SQLHANDLE 00000000
SQLHANDLE * 0x01B671D4 ( 0x01a51540)

660-70c ENTER SQLSetEnvAttr
SQLHENV 01A51540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003
SQLINTEGER -5

660-70c EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 01A51540
SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION>
SQLPOINTER 0x00000003 (BADMEM)
SQLINTEGER -5

660-70c ENTER SQLAllocHandle
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 01A51540
SQLHANDLE * 01B671D8

660-70c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 <SQL_HANDLE_DBC>
SQLHANDLE 01A51540
SQLHANDLE * 0x01B671D8 ( 0x01a515e8)

660-70c ENTER SQLGetInfoW
HDBC 01A515E8
UWORD 10 <SQL_ODBC_VER>
PTR 0x01B671DC
SWORD 50
SWORD * 0x0006B74C

Any suggestions?

Thanks/Mickey Shekdar

 

[SonOfEmidec1100]

Look like an ODBC trace to me. Go into ODBC Data source administrator and stop the trace.

 

[CatPlus]

Hello SonOfEmidec1100:

Thanks indeed... That was the problem! Appreciate your responce

Mickey

 

[SonOfEmidec1100]

No problem, thanks for your acknowledgment.