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...

Good to know! Glad you got it working too.

mw112009 (4/22/2016)

---

The person sitting next to me has access to his local machine.

I think the issue is because I have the STANDARD edition.

The person next to me updated his to...

roni.vered (4/22/2016)

---

Hi there,

For "SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)", it was declared that the SSIS solutions will ONLY work on SQL Server 2014...

Eirikur Eiriksson (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Luis Cazares (4/21/2016)

---

BLOB_EATER (4/21/2016)

---

Luis Cazares (4/21/2016)

---

Brandie Tarvin (4/21/2016)

---

Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread...