Look for the table MSsubscription_agents on your target (subscription) database. make sure that the user you are using for replication has the access on this table.

In transactional repliction When you register a subscriber and run the snap shot agent at the first time, it will create 3 store procedures for each table for insert, update...

Yes

I agree with Antares686 suggestion. but one another way for comparision is to use convert function.

convert(varchar(10),DateTime,101) that will return only date and remove time and you can compare with your...

Thanks, i appreciate your help

g_smilevski

Previously it was giving error because i didn't have SQL Mail in Support Services.

Now it works fine for me. This is perfect.

Thanks