Viewing 15 posts - 4,561 through 4,575 (of 7,484 total)
TDuffy (4/4/2006)
<STRONG>SQLAgentUserRole</STRONG> or <STRONG>SQLAgentReaderRole</STRONG> will work per the source referenced in the QOD.
I made this same mistake (not bothering about local vs multiserver jobs) and am kicking myself for it!
April 21, 2012 at 4:53 am
Surely this question should have asked for multiple answers, not just one? :hehe:
The first option could be the cause. It seems rather unlikely, of course, but it could be...
April 21, 2012 at 4:43 am
The fourth option was obviously a joke, so I was amazed to see that about a qurter or replies selected it! :w00t:
April 21, 2012 at 4:25 am
kangarolf (4/21/2012)
So out of these which would result in a calculation for ALL numbers in the tally table and is there a way of telling?
WHERE NUMBER <= DATEDIFF(M,#FIRSTDATE,#SECONDDATE)
WHERE...
April 21, 2012 at 4:16 am
What Gsquared is saying is right, but it may be easier to understand with a slightly different emphasis.
If you look at the where condition it's
DATEADD(MM,...
April 20, 2012 at 7:18 pm
David Burrows (4/20/2012)
Lynn Pettis (4/20/2012)
Because once in while you think you see a light starting to go on. But then it flickers out again just as fast.
Or maybe it...
April 20, 2012 at 6:56 pm
Lynn Pettis (4/20/2012)
enlightenment
neologism
Why isn't "endarkenment" a word?
edit: fix quote bracket
April 20, 2012 at 6:52 pm
Linson.Daniel (5/30/2008)
April 20, 2012 at 6:46 pm
drnetwork (4/12/2006)
Yalena,
Obviously "the above" doesn't have dynamic scope as that would make thesingle choice questoin invalid - and we all know that no questions at SQL Server Central could ever...
April 20, 2012 at 11:22 am
KarenM (4/20/2012)
I guessed on this one. I've not experienced this error before.
+1
In my case the reason I've never experienced it is that I've never used 2005; but the wrong...
April 20, 2012 at 10:43 am
Revenant (4/19/2012)
capn.hector (4/19/2012)
SQLRNNR (4/19/2012)
Revenant (4/19/2012)
capn.hector (4/19/2012)
crookj (4/19/2012)
SQLRNNR (4/19/2012)
styracosaurusTriceratops
High Tops
Tank tops
tube tops
inner tubes
nanotubes
buckyrods
April 20, 2012 at 1:14 am
crookj (4/19/2012)
SQLRNNR (4/19/2012)
styracosaurusTriceratops
Pentaceratops
April 20, 2012 at 1:07 am
cfradenburg (4/19/2012)
April 19, 2012 at 8:52 am
Nice easy question.
Koen Verbeeck (4/19/2012)
SQLRNNR (4/19/2012)
There needs to be more questions on isolation levels.
Looking at the current score, certainly. 32% for Read Committed.
If Snapshot Isolation was one of the answers,...
April 19, 2012 at 3:46 am
Viewing 15 posts - 4,561 through 4,575 (of 7,484 total)