The business case initially is to have a readable copy out on our Azure environment.  Eventually, we will be moving our application to Azure, which is why we need to...

The table is usually between 1500-3000 rows, so not big at all.  It's fairly simple to just cut and paste an INSERT from SSMS.

I was just trying to avoid those...

The table in question is truncated and repopulated in the production environment at the end of each month.  It contains data that is compiled in other systems; the exact date...

Thanks all for the replies...

The second server in this case is on an environment that is essentially an exact snapshot of our production environment, which is taken over the weekend. ...

That's what I was thinking, thanks for confirming.

I appreciate all the responses.  Unfortunately, the performance seems to be terrible with a join OR with multiple columns being updated.  The tables we need to update are all very...

True...  I'd just have to make sure I declare my variables after the GO...

I was hoping for a more lazy approach I guess, but I think you're right 😀

We are moving our on-prem instance of Microsoft Dynamics CRM to the cloud version - it's MS so basically Azure.  Our head developer gave me a list of things we...

Thanks for the link, that's very useful information.

Some additional information:  I found a fairly consistent "fix" which was renaming the backup set for each database.

Still not clear on *why* that works, though.

Brian - thanks for the reply...

1. The service account definitely has access; and just to be sure I even tried granting "Everyone" full access to the file and folder, but...

Thanks.

We're being audited and we have to explain to them why any that aren't encrypted; so for example I actually had to provide evidence that you can't do the master,...

Thanks.

One additional question...  if I deny these permissions, is it possible to grant them on specific tables, or does the deny override that?

For example, we have a couple of queue...

Ack, nevermind...  I found the problem...

One of the databases we had to restore after the initial outage was master, and the backup was bad; so it was copied from the...

That makes sense.

One thing I ended up trying since I posted was to decrypting one of the databases.  I was able to use the wizard normally at that point -...