SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL Server Erorr Log
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Posting Yak Master

240 Posts

Posted - 08/26/2014 :  09:17:42  Show Profile  Reply with Quote
Hi All,
Is there a way to store the SQL log in table on every half an hour

Almighty SQL Goddess

38079 Posts

Posted - 08/26/2014 :  12:19:44  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes, this will give you an idea on how to set it up: http://www.mssqltips.com/sqlservertip/1750/automate-collection-and-saving-of-failed-logins-for-sql-server/

You'll need to make some changes, but that gives you a good start.

Tara Kizer
SQL Server MVP since 2007
Go to Top of Page

Flowing Fount of Yak Knowledge

United Kingdom
2144 Posts

Posted - 08/27/2014 :  02:34:53  Show Profile  Visit jackv's Homepage  Reply with Quote
You can also use sql statement in this post as basis - changing WHERE predicates to meet requirements. Set up a sql server agent job every half an hr


Jack Vamvas
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000