I am trying to configure database replication within two servers for a database which is being used by my Application. I have configured a distributor successfully, but when i try to create a publication for which the script is provided by my Application vendor, it fails with the following error
Msg 50000, Level 16, State 1, Procedure msdb.dbo.sp_add_jobstep_internal, Line 255 [Batch Start Line 0]
The current transaction cannot be committed and cannot support operations that write to the log file. Roll back the transaction.
Msg 3931, Level 16, State 1, Procedure sys.sp_MSadd_repl_job_unsafe, Line 509 [Batch Start Line 0]
The current transaction cannot be committed and cannot be rolled back to a savepoint. Roll back the entire transaction.