Darkman you rock!!!!
it works perfectly.
now on to my next project... haveing it search the logs for offensive words and email me the report! I have it so that I can search for one word but am getting tripped up on many ohh well I will see what I can do. If you want to see what I have so far...
This is exactly what I planned to do. The problem is the syntax. Thank you for the getdate clue but i need to figure out what 100 days from getdate would be?
would I use something like
DELETE *
FROM webproxy
where ((webproxy.logtime) 100 < GETDATE())
I am very new to SQL and hardly ever use it. I do how ever maintain a proxy server array. So I used a existing SQL server to do the Proxy servers Logging.The database is working just great. The problem is that it is growing very fast and I want the sql server to be able to delete records that...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.