That's very cool, and useful, thanks.

I don't have a setup like your to test against, but - is your server or just database case sensitive?

I believe you'd be able to see the correct case for...

I'm likewise confused as I make use of placing user procs in master named sp_ and unless I actually mark them as system objects they are not.

Just out...

query sys.sysusers for the user name

I'm having problems like this with a sql 2000 AS, we've partially solved this by processing the dimensions sequentially rather than processing the whole cube at once.

You might want to...

The balance between having a clustered index or not is complex, I published an anlysis of index size ( so having a clustered index is covered as part of...

as far as I know you can't move an install - too many registry keys - I'd advise you to uninstall and re-install ( after detaching your databases of course...

that's interesting Eddie, thanks for the recommendations I'll file it away for such time as I might need it.

constants don't belong in sql , set a view as a constant? god help us!

you should set a minimal paging file, the old 1.5 times memory is outdated now on large memory boxes, can you imagine applying this to a server with 128Gb ram?...

thanks for joining in on my question, I didn't expect to evoke this interest level!

So ... yes I agree you shouldn't use floats - but it's not my system...

I'd hate this to end up as a slanging match but the main reason many systems work poorly is the apalling design and implementation of third party applications - usually...

oh I do agree that float is a bad choice.

select sum( convert(numeric(38,28),xxxxxxx)) from dbo.yyyyyy

returns the same value from each server and if I physically convert the float column to numeric(38,28)...

sounds to me you've not set it up correctly - does your data source test work and have you defined the properties of the report correctly.

there's not really enough info to make any guess on your problems. clustering per see should not affect the agent - but it all depends upon the way security and...