wrong, I've found out someone deleted the dates to get around the problem! We've put the dates back in and the problem persists.

Does anyone have any ideas?

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...

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...

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...

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...

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...

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...

Worked a treat, thanks very much for your guidance.

Giles

Thanks Steve, I'll do that right away.

Cheers

Giles

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...

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'

Sorry mislead you, the servers are on different Domains.

Works perfectly thanks, and now I know to look at that area I've found it in the book too!

Thanks again.

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...

Sorry ID 10 T error.

I was still connecting to my backup database. Very very silly. I'll get my coat.