Procedure call through ODBC : LUSENET : SQL Server Database Administration : One Thread

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



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


-- Anonymous, March 01, 2000

Moderation questions? read the FAQ