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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 SQL Server Erorr Log

Author  Topic 

sanjay5219
Posting Yak Master

240 Posts

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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-08-26 : 12:19:44
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
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-08-27 : 02:34:53
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
   

- Advertisement -