Posted by Garry Shutler in Replication
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.
or 
I'm a software developer from Nottingham, working in London, who has a passion for software development.
I'm an advocate of both Test-Driven Development and Domain Driven Design. I've found both make my code easier to maintain and extend and have improved the quality of my code by an order of magnitude.
I will use the best tools available to me which has led me to use Ruby and Rake for scripting and build tasks. I also have dabbled in Rails but not used it for anything serious.
For .NET development I utilise ASP.NET MVC, NHibernate, StructureMap and Resharper.
As well as following this blog, you can also follow me on twitter.
