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 |
|
meet_leo2k
Starting Member
4 Posts |
 Posted - 2008-03-24 : 06:58:04
|
| Hi,I am newbee to SQL server. I am working with SQL Server 2000 in windows 2000 OS. I just want to know whether we can configure SQL server in such a way that it logs all its logs(error/info/warning), irrespective of this severity level, to windows event viewer. Now I can see only system generated logs in event viewer. Can anyone please help??? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-24 : 22:06:22
|
| Why can't look at sql server log? |
 |
|
|
meet_leo2k
Starting Member
4 Posts |
Posted - 2008-03-25 : 01:42:48
|
| I have a WMI agent which collect events only from Windows Event Viewer. I need this log to generate some report. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-25 : 22:56:03
|
| Then you may need edit every system message. |
|
|
|
meet_leo2k
Starting Member
4 Posts |
Posted - 2008-03-26 : 03:52:22
|
| Could you please make your statement clear? I need logs, generated by user activity in SQL server like table create,delete, update etc, into the event viewerThanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-26 : 22:10:02
|
| Sql stores all messages in system table and has option for each message to forward it to windows event log. You have to find all messages that are not forwarded to event log and set the option. Bad news is some messages will not forward to event log even you set that option, based on my experience. |
|
|
|
meet_leo2k
Starting Member
4 Posts |
Posted - 2008-03-27 : 03:41:17
|
| Could you please explain how to enable that? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-27 : 22:44:00
|
| Go to alert under sql agent in em, open any demo alert then you can load all messages there. Each message has checkbox to send it to event log. |
|
|
|
|
|
|
SQL server logs to windows event viewer