Procedure to log a SQL query to the statement log. |
Log the given query and its start time to the SQL statement log. Note that we are logging only the start of the query yet, not a completed query. All the SQL statements are journaled into WebLog.dbo.SQLStatementlog. EXEC dbo.spLogSqlStatement('Select count(*) from PhotoObj',getutcdate()) See also spLogSqlPerformance. |
name | type | length | inout | pnum |
@startTime | datetime | 8 | input | 6 |
@cmd | varchar | 8000 | input | 1 |
@webserver | varchar | 64 | input | 2 |
@winname | varchar | 64 | input | 3 |
@clientIP | varchar | 16 | input | 4 |
@access | varchar | 64 | input | 5 |