title: How do I check SQL replication status via T-SQL?
body: <p>I want to be able to check the status of a publication and subscription in SQL Server 2008 T-SQL.  I want to be able to determine if its okay, when was the last successful, sync, etc.. Is this possible?</p>