Export (0) Print
Expand All

Enabling Logging by the SQL Server CE Server Agent

SQL Server 2000

The SQL Server CE Server Agent is capable of logging errors, warnings, and informational messages to a log file on the computer running Microsoft® Internet Information Services (IIS) server. By default, logging is not available. When logging is enabled, the Sscerepl.log file is written to the IIS virtual directory for Microsoft SQL Server™ 2000 Windows® CE Edition (SQL Server CE). The information recorded in the log can be useful for diagnosing remote data access (RDA) or replication problems.

To enable logging by the SQL Server CE Server Agent

  1. If it does not already exist, create the following registry key:

    HKLM\Software\Microsoft\MSSQLSERVERCE\Transport

  2. Under the HKLM\Software\Microsoft\MSSQLSERVERCE\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 CE. For example, if Sscesa20.dll is located in the NTFS file directory C:\Inetpub\Sqlce\NorthWind, you must name the registry value C:\Inetpub\Sqlce\NorthWind\LOGGING_LEVEL. The data value of the DWORD key must be a value between 0 and 3. The following table describes the data values that may be assigned to the registry key value.
  3. After creating the registry entry, you must restart IIS. This is essential because the SQL Server CE Server Agent reads only the registry key when the SQL Server CE Server Agent (Sscesa20.dll) is first loaded by IIS. To restart IIS, in Internet Service Manager, right-click the server name and select Restart IIS. If you are using IIS 4.0 on Microsoft Windows NT® 4.0, you must restart the computer.
  4. Ensure that IIS is active and that your Web site is started.

The data value contained in the registry entry controls the level of logging that the SQL Server CE Server Agent performs.

LOGGING_LEVEL value Meaning
0 Logging is not available.
1 Log errors.
2 Log errors and warnings.
3 Log errors, warnings, and informational messages.

SQL Server CE Server Agent generates very large log files when you specify LOGGING_LEVEL 3. You should not use this logging level under usual circumstances; however, it is useful when you are attempting to diagnose a problem.

For example, if the Sscesa20.dll is located in the NTFS file directory C:\Inetpub\SSCE\NorthWind, create the following registry key value:

HKLM\Software\Microsoft\MSSQLSERVERCE\Transport
C:\Inetpub\sqlce\NorthWind\LOGGING_LEVEL 3

The key value 3 causes errors, warnings, and informational messages to be logged.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft