I have 2 databases sitting on the same 2008 R2 Sql Server and I am trying to replicate from one to another. I have selected 2 tables and it is failing. I keep getting: "Script failed for Table 'dbo.Agent Master'.
Can someone please help. This seems like the simplest of tasks and I am not sure what I am doing wrong.
I attempted initially to use a domain user that have owner ship rights on both tables. That created another error, so I went and used "Run under the SQL Server Agent server account", even though it is not recommended. That got me to the above error. The previous error was an authority issue.
Thanks in Advance, John