we want to create replication db on our transactional Db. So
Source db: Transactiona Database. For ex: Server A
Destination db: Server B
we wanted to configure using scripts. so our team developed scripts step by step to complete replication. First we want to try on test database to check if scripts are working successfully. so we took copy of transaction db and kept on the same database and ran all scripts. Replication got set up and ran successfully.
Then we tried the same scripts on our transacation db directly, now we received an error
'Implicit conversion from data type datetime to bigint is not allowed. Use the CONVERT function to run this query'