Getting a Stored Procedure to wait 20 seconds

[mch1ck3y]

Hello there - hoping someone can offer some advice.

I am using SQL Server 2000 and want a stored procedure to execute 20 seconds after a particular field on a table is updated using a trigger on the table to be updated. Any ideas on how this would be achievable - any help would be greatly appreciated.

[azimmer]

Hello there - hoping someone can offer some advice.

I am using SQL Server 2000 and want a stored procedure to execute 20 seconds after a particular field on a table is updated using a trigger on the table to be updated. Any ideas on how this would be achievable - any help would be greatly appreciated.

SQL Server has a 'WAITFOR' command; I suggest you read its help.

[ck9663]

Hello there - hoping someone can offer some advice.

I am using SQL Server 2000 and want a stored procedure to execute 20 seconds after a particular field on a table is updated using a trigger on the table to be updated. Any ideas on how this would be achievable - any help would be greatly appreciated.

check the sample here:

http://www.thescripts. com/forum/thread701580.ht ml

[mch1ck3y]

SQL Server has a 'WAITFOR' command; I suggest you read its help.

cheers - much appreciated