Cannot find object because it does not exist...

Chadwick00008Chadwick00008 Posts: 8
edited July 23, 2007 9:55AM in SQL Toolkit Previous Versions
Hello,

I developed an application that synchronizes data in two databases. The client kept getting a permissions error when trying to synch the two DB's, "Cannot find object because it does not exist, or does not have permission.." something along those lines. They gave ownership of the database to the user and this resolved the issue. However, the client doesnt want to give ownership of the database to the specific usergroup and was wondering what specific permissions are required to successfully synch the two DB's.

Thanks for your help,

Chadwick

Comments

  • Ok, I have the issue figured out. One of the database permissions on SQL Server 2005 is called DDLAdmin and needs to be added to the group of users that will be running the script for synchronization to occur.
Sign In or Register to comment.