• Thank you everyone, I was able to take care of my problem,the only thing is when I run sql job for replication:here is the code:runs under Replication snapshot:

    -Publisher [DB1] -PublisherDB [Home_database] -Distributor [DB1] -Publication [home_database] -DistributorSecurityMode 1

    get error:The process could not retrieve information about the transactional/snapshot publication 'Home_Database'. The step failed.How can I fix it?

    Thank you