how to monitor replication? please give me all possible ways?

Well there are many ways, since there are external applications such as System Center Operations Manager etc that can assist in monitoring replication. However the main one is the replication monitor which is accessible via SSMS under replication (right click etc). You can also query the underlying replication tables and could therefore build your own custom monitoring solution via T-SQL and SQL Agent jobs or powershell etc. It really depends on what your requirements are, i.e. do you need to be alerted when there are problems or do you just want to see for yourself the current status of replication. There are also replication events, for example... http://msdn.microsoft.com/en-us/library/ms151752.aspx Thanks/Neil Moorthy - Senior SQL Server DBA/Developer (OCA 11g, MCITP (2005), MCAD) Please click the Mark as Answer button if a post solves your problem