DECLARE @EndTime DATETIME
DECLARE @StartTime DATETIME
SET @StartTime = GETDATE()
--... code here to be measured for duration
SET @EndTime = GETDATE()
PRINT 'StartTime = ' + CONVERT(VARCHAR(30),@StartTime,121)
PRINT ' EndTime = ' + CONVERT(VARCHAR(30),@EndTime,121)
PRINT ' Duration = ' + CONVERT(VARCHAR(30),@EndTime,114) + '(hh:mi:ss:mmm)'
If that doesn't do it, then try SET STATISTICS TIME ON
--Jeff Moden
Change is inevitable... Change for the better is not.