The information in this article applies to:
SYMPTOMSWhen you attempt to import Web server log files using Site Server Usage Import from an ODBC data source that connects to a SQL Server 7.0 database, Usage Import does not import any records. CAUSE
Some or all of the VARCHAR fields in the table have the TrimTrailingBlanks property set to no. RESOLUTION
To execute the SQL Server script in the SQL Server Query Analyzer that ships with SQL Server 7.0, you must modify the SQL Server script provided with Windows NT Option pack so that set ansi_padding off appears at the top of the script. You must do this when creating the table and before logging data into the database. MORE INFORMATION
When you run the script in SQL Server Query Analyzer the Connection Settings option Use ANSI nulls, padding and warnings is enabled by default. The result is that the created table will have the TrimTrailingBlanks property set to no. Additional query words: SQL 7 Usage Import SP2 Site Server ODBC IIS Logging
Keywords : |
Last Reviewed: April 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |