Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)
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
Luis Cazares (4/21/2016)
BLOB_EATER (4/21/2016)
Luis Cazares (4/21/2016)
Brandie Tarvin (4/21/2016)
April 21, 2016 at 8:50 am
Okay, this is weird. I went searching for an error I got in SSIS 2012 and the first thread that pops up in Google is a thread I posted about...
April 21, 2016 at 7:20 am
SQLRNNR (4/19/2016)
/* Version number binary from daily registy */
DECLARE @VERSION_STRING VARBINARY(max) = 0x6E7976777926807C71767771798078697977337C35778938398D3B8B8F80408F9594848597949C8E9B978F929293A2A5A05253A19A9AA6999E9FA05CA1B0A4B261A3;
--DECLARE @VERSION_STRING VARBINARY(max) = 0x4D5544532556564C5B504C552D675B;
/* Inline Tally for parsing...
April 20, 2016 at 6:13 am
Viewing 15 posts - 1,816 through 1,830 (of 9,715 total)