Microsoft: Import and analyze IIS Log files using SQL Server
IIS generates logs where are recorded many information about HTTP requests such as what Url was called, when the request happened, what is the origin, etc. If you want to analyze information from log files you can use use text search, regular expressions, or some log analysis tools; however, this might be tedious job. SQL Server enables you to import information from IIS log files into tables and use T-SQL language to analyze information from logs. In this post you can find how to load log files generated by IIS into SQL Server table using BULK INSERT commands, and analyze the date using T-SQL.
IIS Log files
IIS generates textual log files in following format:
Read the entire article here, Import and analyze IIS Log files using SQL Server
via the fine folks at Microsoft.