触发或存储锁定数据库15分钟 [英] Trigger or Stored for lock database for 15 minute

问题描述

亲爱的先生，
我创建了一个登录表单，如果您输入的密码错误3次，则您的帐户将在接下来的15分钟内被锁定.
并且我们会在15分钟后发送参考电子邮件ID上的随机密码.
在这15分钟内，帐户处于活动状态="false".

因此，您能否帮我提供存储过程或触发器的代码，该代码将在15分钟后触发，从而更新此帐户isactive =" true".

请帮帮我.

在此先感谢

Dear Sir,
I create a login form in which if you insert password 3 times wrong then u r account is locked for next 15 minute.
and we send a random password on referenced emailid which is sent after 15 minute.
For these 15 minute the account isactive=''false''.

So can u please help me to give code for a stored procedure or triggers which is fired after 15 minute,which update this account isactive = ''true''.

Please help me.

Thanks In Advance

推荐答案

存储的过程和触发器不会自行触发.如果您使用的是标准版，请每隔15分钟使用SQL Agent的工作进行一次检查( http://msdn.microsoft.com/en-us/library/ms187910.aspx [ SQL代理: Job Scheduler Framework [^ ]

Stored procedures and triggers don''t fire themselves. If you have standard edition, use SQL Agent''s job to do the checks every 15 minutes ( http://msdn.microsoft.com/en-us/library/ms187910.aspx[^] ).

If you use Express edition where agent is not available you can create a small service to do the checks or perhaps use SQL Agent: A Job Scheduler Framework[^]

这篇关于触发或存储锁定数据库15分钟的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！