SQL Server Erorr Log - SQL Server Forums

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/

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources