PROCEDURE  spLogSqlStatement

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.

Input and output parameters

nametypelengthinoutpnum
@startTimedatetime8input6
@cmdvarchar8000input1
@webservervarchar64input2
@winnamevarchar64input3
@clientIPvarchar16input4
@accessvarchar64input5