replication

• bryan99y

  SSCarpal Tunnel

  Points: 4672

  More actions

  June 6, 2003 at 9:03 am

  #64856

  I have snapshot replication setup in a sql server 2000 environemnt. I want to be able to check whether the snapshot failed and write to a text file if it failed.

  What replciation table has the success/failure for snapshot?

  Is there another way here? It's just the sql server's are on a different LAN and SQL Mail does not send out.

• Shas3

  Hall of Fame

  Points: 3671

  More actions

  June 6, 2003 at 9:43 am

  #460215

  MSsnapshot_history table contains the details you are looking for. You can see this in the Distribution database.

  Select Agent_ID, runstatus, start_time from Mssnapshot_history where runstatus = 6

  Shas3