import from sql tables into windows event viewer

Question

import from sql tables into windows event viewer

aureliu

SSC-Addicted

Points: 430
More actions
January 7, 2020 at 12:33 pm

#3713159

Dears,
I need some ideas about how to export from 2-3 sql server tables ( filled with app messages) and import into windows event viewer application/security ?
Thanks,
Hadrian

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sue_H SSC Guru Points: 90859 More actions · Answer 1

I don't think you can import those into the event logs. You would probably need to read the rows and write those to the application log. One possibility would be using xp_logevent but it also writes to the sql error log.

Sue

Michael L John One Orange Chip Points: 26292 More actions · Answer 2

What are you ultimately trying to do?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

aureliu SSC-Addicted Points: 430 More actions · Answer 3

there is an app who insert error messages into 2-3 tables and other application who analyse the event viewer logs . The task is to import into event viewer the messages from sql tables .

Regards,

Aureliu

Michael L John One Orange Chip Points: 26292 More actions · Answer 4

I have nothing better than Sue's suggestion about using xp_logevent.

I guess my question would be is can the developers modify their code to write to the windows log, in addition to the tables?

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

aureliu SSC-Addicted Points: 430 More actions · Answer 5

I'm unsure but there aren't developers in order to make app's changes.