July 18, 2007 at 8:40 am
It appears with SQL 2005 that the 14150 event is not logged in the Application Log. We relied on this heavily in SQL 2000 replication. We were using alerts to send an email to a department so they were aware when a user synchronized successfully. Did Microsoft remove this event from the SQL logs or is it a bug? If they removed it - then why is there an alert that one can setup for it? Any help or workaround is appreciated!
July 18, 2007 at 12:50 pm
That alert Message Apears as NOT logged on 2000 also.
If you are currently ussing it in 2000 someone/something marked it as logged. You could marked it as logged using
sp_altermessage
* Noel
July 19, 2007 at 7:09 am
I should've mentioned...
I tried the sp_alertmessage but that sp only works on messages 50000 and above. I don't recall doing anything special with SQL 2000 - other than enabling the alert (replication - success).
Any other ideas?
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply