The Microsoft SQL Server Compact 3.5 Server Agent can log errors, warnings, and informational messages to a log file on the computer running Microsoft Internet Information Services (IIS). By default, logging is not available. When logging is enabled, the sqlcesalog.txt file is written to the IIS virtual directory for SQL Server Compact 3.5. The information recorded in the log can be useful for diagnosing remote data access (RDA) or replication problems.
Enable Logging by the SQL Server Compact 3.5 Server Agent
Create the following registry key, if it does not already exist: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\TRANSPORT.
Under the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v3.5\TRANSPORT key, create a DWORD key value. The name of the key value must begin with the local path associated with the IIS virtual directory for SQL Server Compact 3.5. For example, if Sqlcesa35.dll is located in the NTFS file directory C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\sql, you must name the registry value C:\Program Files\Microsoft SQL Server Compact Edition\v3.5\sync\sql\LOGGING_LEVEL.
The data value of the DWORD key must be a value between 0 and 3. The data value contained in the registry entry controls the level of logging that the SQL Server Compact 3.5 Server Agent performs.
The following table describes the data values that should be assigned to the registry key value to define the level logging:
LOGGING_LEVEL value
Description
0
Logging is not available.
1
Log errors.
2
Log errors and warnings.
3
Log errors, warnings, and informational messages.
Important SQL Server Compact 3.5 Server Agent generates very large log files when you specify LOGGING_LEVEL 3. You should not use this logging level under usual circumstances, but it is useful when you are attempting to diagnose a problem.