I have moved my active blog over to tumblr. I've maintained this blog for reference but will be posting to http://www.robustsoftware.co.uk instead. I've pointed my Feedburner feed to tumblr so if you're subscribed already you should already have switched with me.

SQL Server 2005 replication errors table

Just a quick one so I have this as a reference as it takes me a while to find it each time I forget.

The SQL statement to get the errors from replication as the ones the monitor gives you can be very vague is:

select * from msdb.dbo.sysreplicationalerts

Note that it is only a status type message unless error_id is not zero.