write all error log sql on windows application event log

bibi92
bibi92 used Ask the Experts™
on
Hello

how can I write all error log sql on  windows application event log?

Thanks

Regards
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
IT Engineer
Distinguished Expert 2017
Commented:
It's already written in Application Event Log so you just need to create the a MSSQL Custom view and for that open Event Viewer and chose the option "Create Custom View..." and then check the Event levels that you want and check "By Source" so you can chose from the combo box all MSSQLServer related events.
EventViewer---CreateCustomView.PNG

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial