Solved

SQl error event viewer

Posted on 2011-02-18
4
311 Views
Last Modified: 2012-05-11

Is there a way to get notified when there is a speicific SQL error in event viewer?
0
Comment
Question by:Nana Hemaa
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 250 total points
Comment Utility
Win Server 2003 doesn't have a native way of doing this. You can use Log Parser from Microsoft (http://technet.microsoft.com/en-us/scriptcenter/dd919274.aspx)

Win Server 2008 has the feature to send email notifications on specific event types (http://www.vistax64.com/tutorials/67961-event-viewer-email-notification.html)
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 250 total points
Comment Utility
In my opinion is best to setup and use SQL Server Alerts why to wait for them to get in the event viewr and parse the viewer then send an email when you could set up an alert in sql for speciffic error and send notification when it occurs.

http://msdn.microsoft.com/en-us/library/ms180982.aspx
0
 

Author Comment

by:Nana Hemaa
Comment Utility
tried that but could not find specific alert in the drop down for
17054,
 Severity: 16, State: 1.
0
 
LVL 39

Expert Comment

by:lcohan
Comment Utility
Open SSMS, connect with a sql sysadmin user, expand SQL Agent at the bottom, right click alerts and select new then a window pops up where you should click "Error number" like in attached picture then type in your number and go from there - check "Response" and "Options" on the left panel for more stuff you can do based on that error code.
Alert.png
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now