I'd like to make a trigger which creates an entry in the Windows Application Event Log. Unfortuantely, the xp_logevent extended stored procedure is not working properly, even when I run the command directly as follows:
osql -E -S databasename
exec master..xp_logevent 60000, 'Test', 'warning'
For some unknown reason, xp_logevent is only logging to the ERRORLOG file and nothing appears in the Windows Application Event Log.
My account is a domain administrator and, for good measure, I've granted it the Systems Administrator server role on the servers, and db_owner database role on all the databases on the server.
The SQL Server version is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Desktop Engine on Windows NT 5.2 (Build 3790: Service Pack 2)
After trawling the web I can't find anything that might explain why this doesn't work. Any help in fixing or diagnosing this problem would be appreciated.
Ade.