Logging NT Events

[ipramod]

Hi,

Is it possbile to retrieve all the Event Id's of a registerd source
(Ex. MSSQLSERVER)? If it possible then can we retrieve the description
of those Event Id's and can we generate the NT Event with the above NT
Event and the desc for that?

Some how I retrieve all the Event Id's of SQL Server application and
then for each Event ID retrieve the Event Id Description and gererate
the same NT Event.

SMGENIE.EXE from MS Resource kit do the same.

Can anyone please let me know if its possible.

Thanks in advance,
Regards,
Pramod

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,


Well, suddently this is a very demanded request

You need to know the eventID & description for ALL the possible events,
where to find this? maybe in some SDK or in some docs.

A brute solution could be force the SQL server to generate ALL possible
errors and then read them from the event log , then you will have a complete
list of the possible errors.

 

[ipramod]

Hi Ignacio Machin,

So, there is no way to generate SQL Server specific events manually. I
have a code which generate SQL Server events but the description for
those events is following which is not as per expectation:

The description for Event ID ( 17176 ) in Source ( MSSQLServer ) cannot
be found. The local computer may not have the necessary registry
information or message DLL files to display messages from a remote
computer. You may be able to use the /AUXSOURCE= flag to retrieve this
description; see Help and Support for details. The following
information is part of the event: "<Custom Message>".

<Custom Message> is the only message I want in the description part of
the NT Event. but it is giving the improper desc.

So can we atleast generate the proper message of the corresponding
event ID for an NT event?

Let me know ASAP.

Regards,
Pramod

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

you better post this question in a SQL NG, but the msg is clear, you are
missing something where the description for the error is.