Viewing 15 posts - 121 through 135 (of 429 total)
SysJobHistory is where you want to look, but you'll probably need to pick up the detailed message from the job step that failed rather than the message on the job...
March 23, 2015 at 2:35 pm
Rune Bivrin (3/23/2015)
March 23, 2015 at 7:14 am
Ugh, why would they limit you like that! :-D:laugh:
February 27, 2015 at 7:01 am
Objects such as tables aren't really owned by a user. They are owned by a particular schema. Schemas are owned by users.
You can find out what schemas there...
February 19, 2015 at 9:59 am
david.gugg (2/19/2015)
Wait, so if the memory optimized filegroup is not encrypted, does that mean the data is vulnerable? Should in-memory OLTP tables not be used with sensitive data?
Encrypted filegroups...
February 19, 2015 at 7:44 am
This comes in quite handy if you want to grant access to a stored procedure that requires some elevated permissions to run, but you don't want to grant those rights...
February 9, 2015 at 7:12 am
I chose GROUPING as well, as Count only includes NULL values for the special case of Count(*):
SELECT
Count(*),
Count(MyValue),
FROM
(
VALUES (1), (2), (3), (NULL)
) AS X (MyValue)
January 7, 2015 at 7:17 am
There are a few ways to prevent the package from failing when the file(s) are not there.
One is to change the package properties so that it reports success...
December 8, 2014 at 10:14 am
Hugo Kornelis (11/26/2014)
The code in option 2 will always do two lookups. One for the EXISTS, and then another one for...
November 26, 2014 at 7:02 am
Interesting question, thanks for submitting!
November 19, 2014 at 7:17 am
Stewart "Arturius" Campbell (11/13/2014)
Good question, thanks SteveFound myself looking for a catch, but went with my knowledge anyway.
Yea, I spent a bit of time trying to figure out the catch...
November 13, 2014 at 7:53 am
Was very confused when I got this wrong... didn't even notice the duplicate answers. :blink: :rolleyes:
November 11, 2014 at 7:29 am
Ed Wagner (10/3/2014)
SqlMel (10/3/2014)
But I must say that I do not use this feature in my coding.
I haven't either. I'd use TOP myself, but this is another nice tool...
October 3, 2014 at 9:09 am
GilaMonster (10/1/2014)
Sean Pearce (10/1/2014)
Roland C (10/1/2014)
Another badly redacted question ! It gets a little boring :doze:You could always submit your own question.
This kind of reaction is why I don't submit...
October 1, 2014 at 6:57 am
Arrrrr.... it be a shame ta not be postin' this question on September 19!
September 24, 2014 at 6:25 am
Viewing 15 posts - 121 through 135 (of 429 total)