I have a procedure that does a time tracking on how long the procedure took to execute. This procedure is called from an application through ODBC. A skeleton of this procedure looks like proc ( starttime = getdate() .... select * from ... endtime = getdate() executetime = endtime - starttime ) .

Does the execute time include the data transfer through ODBC ? THanks in advance.

-- Anonymous, March 01, 2000

Answers

Rajesh,

No. The execute time calculated in this way will not include the ODBC data transfer time.

Eric

-- Anonymous, March 01, 2000