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.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2002-01-30 : 03:07:12
|
Hallo, here I am again trying to understand more about SQL Server. Why it is 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? Thank you for your time. Best Regards.  |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-30 : 12:53:08
|
| Are you doing this in the 'manage messages' tool? (All tasks->Manage Messages)There should be an option: 'Always write to Windows NT event log'Make that false. You may need to restart SQL Server before the change takes affect, I'm not sure.-Chad |
 |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-01-31 : 02:46:47
|
Chad, thank you for your answer but it did NOT work.I know there is an option 'Always write to Windows NT event log' but even if you clear it and you stop and restart SQL Server, still the message of backup database appear on the Application event log of NT. Any other idea?Franco |
|
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2002-02-07 : 05:27:38
|
| Hallo, here I am again because Microsoft has answered to my question and I woul like to let you know what it is all about. Thank you anyway. Regards. Hi Franco, The option is intended to work with RAISERROR statement and user defined error messages (however, the GUI is somewhat misleading). To be a little bit hacky, you can try "RAISERROR(16824, 10, 9)" to verify the option does work. Why it seems not working is because the SQL Server doesn't use RAISERROR to write the message to the error log and event log when backup completes. System messages will write to the error log and event log whenever appropriate regardless this option. Thanks and regards, Liu An Microsoft Support Engineer |
|
|
|
|
|
|
"LOGGED" error message