Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

"logged" error message

Status
Not open for further replies.

francox

IS-IT--Management
Jul 19, 2001
26
CH
I use SQL Sever 7 sp1 and SQL Server 2000 sp2.
Question:
Why is it that if you can clear the check on a "LOGGED" error message like 18264 DATABASE BACKED UP...still this message appear on the application event log of NT when you perform a backup? Seeems like this check is useless...
How can I stop this message and other "logged error" on the application Event Log?

Details:

Right-click a Server, then "All Tasks" and then "Manage SQL Server Messages". Search (find button) 18264 Error message.
You can edit this SQL Server message and you see that it is a "LOGGED" error message.
If you then edit the message there is a check "always write to Windows eventlog" set to true.
If you clear this option the message still appear in the windows application event log whenever you perform a database backup (error number 18264).
Stop and start SQl server do NOT help.
Thank you for your time.
Franco
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top