WAITFOR DELAY '000:00:05'

[NickName]

Env: SQL Server 2000

It actually waited for 50 seconds instead of 5, tried
WAITFOR DELAY '000:00:005' and WAITFOR DELAY '000:00:5' respectively,
and got same behavior. Bug or ?

TIA

[debian mojo]

WAITFOR DELAY '000:00:005'

Well as you know the the time value you pass is a datetime value minus
the date part.

Now what is the smallest precision of time is datetime? Does it make
any sense to use 005 in place of 05 if what you really want is just 5
sec. If you want to look deeper into this and a smaller unit than a sec
try using:
WAITFOR DELAY '000:00:05:05'
Regards
Debian
*** Sent via Developersdex http://www.developersdex.com ***

[NickName]

All right, 005 was thoughtless. And yet the strangest thing is, now,
WAITFOR DELAY '000:00:05' waited for 5 seconds as intended while a few
hours ago it waited for 50 seconds on the same machine. Well, it seems
that the machine is definitely not MINE.

[Stu]

Did you check the CPU activity and other indicators of resource
utilization while it was WAITING? Could be something else was going
on....

Stu