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

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

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