how can I read a table value every minute

Hi
I was wondering if there is any function by which I can read the value in a
date field every minute or so to check to see if it has been updated.
In MS Access I would have done this using the timer function but I wonder if
there is an equivalent in MSDE.
Thanks
June
hi June,
"June Macleod" <junework@.hotmail.com> ha scritto nel messaggio
news:OrxlWq4gEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi
> I was wondering if there is any function by which I can read the value in
a
> date field every minute or so to check to see if it has been updated.
> In MS Access I would have done this using the timer function but I wonder
if
> there is an equivalent in MSDE.
>
MSDE provides access to the SQL Server Agent, a native scheduler which can
be used to execute maintanance jobs, execute Transact SQL staments, run
stored procedures...
perhaps you can use it... server side... instaead of a client timer...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||June,
Depending on what you are up to, you might find the WAITFOR command useful.
Russell Fields
"June Macleod" <junework@.hotmail.com> wrote in message
news:OrxlWq4gEHA.632@.TK2MSFTNGP12.phx.gbl...
> Hi
> I was wondering if there is any function by which I can read the value in
a
> date field every minute or so to check to see if it has been updated.
> In MS Access I would have done this using the timer function but I wonder
if
> there is an equivalent in MSDE.
> Thanks
> June
>