As a systems analyst/information analyst who was unaware that they had demised i think there is a fundamental barrier for many small to medium sized businesses when looking at BI projects, namely timescales. Our business...

Hi,

Yes i have done that, I ran SQL2000.AS-KB884525-SP4-x86-ENU.EXE on the server. Analysis manager on the server is showing that sp4 has been installed but analysis manager on my desktop says it's still unpatched and...

Hi,

Doh! thanks that's exactly what I needed. The meta data report is correct - or more accurately it's the same value as appears in the folder where the cube...

Hi,

This should answer your first question

http://support.microsoft.com/kb/q297502/

As to your second problem.

Without seeing all of the code it's diffcult to be 100% precise however the Jet error in these situations is...

Western Governments have talked for some time about securing energy supplies, i wonder if it is time to start the debate in business about the security of labour supplies. Whether...

As a new comer to this site I didn't feel it was necessary to make any comment either way on the issue of the sale or the possible ramifications to editorial independence....

I think it also depends on the company you work for especially the size of the company. I'm employed as a systems developer, what that actually means is DBA/developer, Access...

The obvious answer is that all ad-hoc data requests need to be logged. If every one is aware that there is an audit trail then it should deter people from...

Clearly the bottom half

Spotted me then

Thanks Lynn that compiles nicely

Just one question,

Should set @var_st_lev in

set @var_st_lev = CASE

Hi, Yes that would be very helpful as this attempt failed with even more errors

Thanks

K.

CREATE FUNCTION dbo.NewStockLevel

(

    @var_st_lev int,

    @var_stt_amnt int

)

RETURNS...

Hi,

Thanks for everyones help and support

I've managed to work out a solution for the time being.

As i'm building a mirror of the transaction...

Hi,

Thanks for the ideas. Bizarrely i tried running an Access query against the table linked via the obdc and it couldn't find the 01/10/1899 records it's as if they don't...

Hi, Thanks for spotting that Once that was fixed I also noticed that i'd copied a couple of the temp table field...