Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcarver
Starting Member
18 Posts |
 Posted - 2007-10-11 : 16:23:41
|
| I have just come into a company that is running older SQL 2000 and I need to do some complex time logging. I have a table that logs some incorrect logins, this table logs their incorrect "user's" attempted username as well as the date. I need to be able to send a SQL based E-mail there are more than 10 incorrect logins in a minute or under and then change a field in another table to "disabled" for that username if it exists. I have no idea where to start on this. Thanks in advance,/jcarver |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2007-10-11 : 19:53:50
|
| hmm. This is an interesting one. There are many ways to skin this cat. Apologies to cat fans everywhere. Anywhoo, if the table you're logging the incorrect logins to also has a datetime field, then you're almost there. A simple trigger on the table to evaluate the username in the inserted table and the current date/time against the table you log the info to would give you whether you had x logins in x minutes. After that it should be a simple call out to an sp or tsql from your trigger to disable the login.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Executing a command after time