Hi ,

I would want my replication alert to write a log into the Event view , how
can i do that ?

i looked thru the Replication Alert properties but dun seem to be able to
find some method

how can i actually do that ? and if codings are required how shld it be
written

appreciate any advise

tks & rdgs

--

Open up the replication alerts folder, double click on the alert you are
interested, click on the browse button (the three ellipses), click on the
edit button, select always write to the Windows Event Log.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

I'm not too sure if there's a better way, but as a workaround you could
execute a job which contains xp_logevent.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Nice solution - knew there must have been something better!
Rgds,
Paul Ibison

tks ppl for the information appreciate it
[quoted text, click to view]

--
Message posted via SQLMonster.com