No, it did not, actually. Weird...

Thank you. 😀

Best Kylo Ren Twitter account ever.

Lynn Pettis (4/26/2016)

---

Brandie Tarvin (4/26/2016)

---

[headdesk]

Seriously. SERIOUSLY?

Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this...

This is our test environment. We're testing the vendor move to SQL 2012 before moving it...

[headdesk]

Seriously. SERIOUSLY?

Because Public had a DENY on BACKUP DATABASE, it wouldn't let my account backup the database. I found it using the below code from this link.

SELECT b.name, CASE a.protecttype...

Hrmpf.

Nope. Doesn't fix it. Still with the permission error on BACKUP DATABASE. And the backup command works. I've printed it out to the job log and run it myself. So...

Lynn Pettis (4/26/2016)

---

Found this doing a search:

If you will assign user as db_backupoperator you will discover error when you will try to create a backup..

When trying to specify location, you...

We...

There were no deny perms initially. I double-checked, there are none now.

Any other ideas?

Oh, here's two in German that I learned from a coworker when I was in high school.

Er/Sie hat nicht alle tasse im Shrank.

and

Du hast ein Vogel.

Roughly translated as "He/She doesn't...

J Livingston SQL (4/25/2016)

---

BWFC (4/25/2016)

---

Luis Cazares (4/25/2016)

---

Ed Wagner (4/25/2016)

---

Jeff Moden (4/24/2016)

---

TomThomson (4/22/2016)

---

Phil Parkin (4/22/2016)

---

Eirikur Eiriksson (4/22/2016)

---

Brandie Tarvin (4/22/2016)

---

In this case I did add my two cents because I've seen that...

frederico_fonseca (4/22/2016)

---

Installing Visual Studio 2015 does not prevent you from installing Sql Server Data Tools for visual studio 2012 or 2013 - you can have all 3 versions installed of...

In this case I did add my two cents because I've seen that damn failure before and it took me days to figure out what the issue was the first...

The most common cause of a TRUNCATE TABLE failure is the login running the code doesn't have db_owner on the database or ALTER permissions on the database. ISTR that even...