SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
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  

sanjay5219
Posting Yak Master

230 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

tkizer
Almighty SQL Goddess

USA
37133 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
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2067 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

http://www.sqlserver-dba.com/2007/03/sql_server_log_.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
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.11 seconds. Powered By: Snitz Forums 2000