My scenario is this... We currently use database projects for our SQL development and then use Finalbuilder to deploy the project once a build is created (dacpac). This is then applied to the database but..we have replication for several articles in the database and this needs to be dropped beforehand and then created afterwards making this a bit of a manual process. I want to automate this for our Nightly builds but it seems that the script to drop and create has to be performed as a sysadmin and I don't want to give build accounts those elevated priveleges.
Has anyone had this experience and found a way around it?
All suggestions taken with thanks
Every day is a school day, and don't trust anyone who tells you any different.