May 25, 2006 at 7:06 pm
Here i have an interesting issue.
I have a Database that is configured for Transactional Replication to another Database on a different Server. When a transaction is pushed to the Subscriber I get an error that states "Invalid Object Name tblXYZ"
The table definitely exists at the Subscriber!
I need to mention here that the tables are not owned by dbo, they are owned by another user called mprop.
One more thing to mention is that I didn't allow SQL Server to do the initial snapshot as the database is 5GB, so I backed it up restored it to the destination server and configed the subscriber without doing the snapshot.
Can any one help?
May 25, 2006 at 7:30 pm
Are you able to change the ownership of the table (sp_changeobjectowner)? Ideally, tables should be owned by dbo, unless there is a good reason not to!
May 26, 2006 at 3:30 am
what account run the replication on the subscriber (if it's pull) or publisher (if it's push) - does this account have permission to use this.
i'm guessing that your account can't access owner.table and is trying to update dbo.table
also have you created the owner account on the target server and run sp_change_users_login on the subcriber to correct the orphaned login from the restore
MVDBA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply