Force sql serve to write to eventlog
The list of all SQL Server errors:
SELECT * FROM sysmessages where msglangid = 1033
I want to force SQL Server to write all errors with a servery higher than X to the operating system event viewer because it's the only way I have to capture sql server errors with my office monitoring tool.
How to do it ?
Last Comment
lcohan
You could set a New SQL Alert under SQL Agent in SSMS that can do that for you.
ASKER
Help, I don't find how to write to event viwer ..
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Perhaps I am being dense but if you want to write to the Event Log, have you considered something like this:
RAISERROR ('Houston we have a problem!', 10, 1) WITH LOG
RAISERROR ('Houston we have a problem!', 10, 1) WITH LOG
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks !
Microsoft SQL Server 2008
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.
50K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
