Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)
Lynn Pettis (4/26/2016)
Can you recreate the issue with a sandbox database in a test/development environment?
This is our test environment. We're testing the vendor move to SQL 2012 before moving it...
April 26, 2016 at 11:02 am
[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...
April 26, 2016 at 11:01 am
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...
April 26, 2016 at 10:52 am
Lynn Pettis (4/26/2016)
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...
April 26, 2016 at 10:47 am
Steve Jones - SSC Editor (4/26/2016)
Loguser_name()
suser_sname()
etc. (there are a few more)
into a table before the app runs the command (and the command). Check there isn't any impersonation.
We...
April 26, 2016 at 10:33 am
There were no deny perms initially. I double-checked, there are none now.
Any other ideas?
April 26, 2016 at 7:54 am
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...
April 25, 2016 at 7:42 am
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)
April 25, 2016 at 7:24 am
frederico_fonseca (4/22/2016)
April 25, 2016 at 5:41 am
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...
April 22, 2016 at 12:39 pm
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...
April 22, 2016 at 12:38 pm
Good to know! Glad you got it working too.
April 22, 2016 at 12:13 pm
mw112009 (4/22/2016)
I think the issue is because I have the STANDARD edition.
The person next to me updated his to...
April 22, 2016 at 10:18 am
roni.vered (4/22/2016)
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...
April 22, 2016 at 5:16 am
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)
April 21, 2016 at 9:21 am
Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)