The permissions should be the same. The GUI, whether it issue PoSh or T-SQL, is just asking the services to perform a backup.

Likely something is being done differently between the...

Reporting this to the staff. Not sure what's going on.

A snapshot is like another database, but it doesn't allow you to backup/restore.

As Jack mentioned, a backup is probably a better choice for bringing things up to date. Otherwise you...

The problem is that far too many of us travel for work. Leaving a laptop/cell phone behind isn't an option.

You can grant rights on the certificates to users. Without rights, they can't open it and use it for decryption/encryption.

http://blogs.msdn.com/b/lcris/archive/2005/06/10/sql-server-2005-column-encryption-demo-part-2.aspx

Those names are added.

Actually, as an FYI, you only need to report one post from a user. Once we get the name, we ban the user immediately.

Sean Lange (8/19/2014)

---

Steve Jones - SSC Editor (8/19/2014)

---

We are aware of the issue. When we see SPAM, we ban the account, and all posts get deleted, but it does take...

I've also set our "remove all posts by person xx" job to every 5 minutes, which will help.

Unfortunately, I really need some front end development that will ignore some of...

Scientist v engineer. I could see why some people prefer the latter, but that's a little pedantic. Plus it didn't flow off the tongue as well.

I think I got...

Gary Varga (8/19/2014)

---

I agree that is...

We are aware of the issue. When we see SPAM, we ban the account, and all posts get deleted, but it does take a little time.

I have escalated this as...

cheers

FYI, here's the explanation from MS:

Some of the columns that contain pre-defined strings (like types, system description, constants) are always fixed to a specific collation – Latin1_General_CI_AS_KS_WS. This is irrespective...

I won't be taking Peyton Manning again this year. I was sooooooo glad I passed on him for Cam Newton last year </sarcasm>

I'd agree with Jason. Enlarge your tempdb log. 47MB is small and space is relatively cheap. It's not worth these errors.

I'd probably grow to 1GB and monitor the space usage...