Viewing 15 posts - 31 through 45 (of 67 total)
On instinct I've looked in the Date and Time settings in Control Panel, there were set to dd/MM/yyyy as I'd expected, so I switched them to MM/dd/yyyy and the dates...
October 2, 2014 at 10:46 am
Thanks Scott.
I did check the values are set (there is a bit commented out) plus it doesn't explain how it runs in isolation but not when the whole script it...
June 9, 2014 at 1:51 am
Hi Sean,
Thanks for looking, however I think you've misread the code.
You're correct that the EXISTS is checking to see if @LowID is already in the LookupPriorityID column but then I'm...
June 6, 2014 at 9:29 am
A fair comment Kevin, thanks.
I've taken the time to create a non sensitive version of the script and attached it (Problem Script.zip).
It might also be worth mentioning that, because the...
June 6, 2014 at 8:35 am
Thanks for your interest and ideas.
sqldba725, We were connecting "using the logins current security context".
The Master and Server A both use Windows Authentication and Server B is in Mixed...
February 13, 2014 at 10:31 am
I still don't understand why when executing the stored proc under the guise of domain\agent isn't working against Server B but setting the owner of the Job to be domain\owner...
February 10, 2014 at 6:55 am
Worked a treat, thanks very much for your guidance.
Giles
April 26, 2013 at 10:34 am
Thanks Steve, I'll do that right away.
Cheers
Giles
April 26, 2013 at 1:53 am
Thanks Steve, really appreciate you taking the time to answer.
Won't your suggestion only show the products selected in you filter though?
Let's say I've got 26 products A through to Z.
I...
April 25, 2013 at 8:19 am
Sorted, as I'm only using the Linked Server for this activity I've configured it to ignore remote proc transactions.
EXEC master.dbo.sp_serveroption @server=N'XX.XXX.XX.XX', @optname=N'remote proc transaction promotion', @optvalue=N'false'
January 10, 2013 at 7:22 am
Sorry mislead you, the servers are on different Domains.
January 10, 2013 at 6:50 am
Works perfectly thanks, and now I know to look at that area I've found it in the book too!
Thanks again.
January 9, 2013 at 10:33 am
I rewrote the calculation to be a tuple
([Advance Period].Period.[All],[Measures].[ReferencePeriod])
and it was consistent between XML and the Calculation.
So I've got my result but it would be interesting to know what the...
November 23, 2012 at 6:25 am
Sorry ID 10 T error.
I was still connecting to my backup database. Very very silly. I'll get my coat.
November 20, 2012 at 9:23 am
nah, sorry changing the DB owner didn't work for me.
October 12, 2012 at 6:47 am
Viewing 15 posts - 31 through 45 (of 67 total)