| David Wang [Msft] 2005-03-08, 2:48 am |
| I suggest you write a Stored Procedure in SQL to do this, and then the ASP
page simply configures the Stored Procedure with the right parameters.
Otherwise, you will need to write a page which writes a script that executes
as a user with write permissions to the SQL Server on recurring schedule.
Way too many interactions, too many security concerns, etc. You literally
want to allow the remote user to be administrator on this server to do
things, which is never wise from a security perspective.
--
//David
IIS
http://blogs.msdn.com/David.Wang
This posting is provided "AS IS" with no warranties, and confers no rights.
//
"Marcin Zmyslowski" <marcinz@kapy.bydg.pl> wrote in message
news:ecT8lvDIFHA.2984@TK2MSFTNGP15.phx.gbl...
Hello all!
Is it possible to generate some script which will be deleting one value
from specific field from MS SQL Server 2000 (which is a datetime field)
when the date value is 15 minutes older than the current time. But I
want this script to be generating periodicaly in each 5 minutes? Is it
possible to do it? I am creating a www page on ASP platform using
VBScript and users will be changing this datetime value field after
clicking on submit button.
Thank you for help
Marcin from Poland
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|